Need an Excel Spreadsheet to Automatically Update a Table

[gaRed]

Normally, I'm not an excel user so my quesion may seem a bit easy. I have an excel spreadsheet that the user enters production information into. There are many ranges. The user wants the Totals to automatically populate a table, instead of her having to type in all the spreadsheet data, and then filling in the table too. My problem is, production can vary for each week that she enters in. This would change the range. How would I go about automating this spreadsheet so that it updates the corresponding table?

 

[SkipVought]

gaRed,
Please be more specific. How are production info, ranges, table related. When you refer to a table, is this a table with headings in a worksheet? What are the major headings in the table? How is that related to the production info? Where do the totals come from? What do you need to happen to the totals in the table?

Maybe you ought to launder your workbook and send me an abbreviated copy. I'll be glad to look at it.
Skip,
SkipAndMary1017@mindspring.com