Transferring Data from multiple worksheets to a master worksheet

[jdwoods]

I have a Workbook that contains 7 works sheets, when the data is entered into one of these worksheets I would like the Data to be automatically entered into a monthly summary worksheet, i do not want to just to be a copy and paste though just case data in one of the seven have to changed it would change automatically in the monthly summary. ANy insight would be great as I am still fairly new at trying to figure more thanthe basics with excel.

 

[doublej_jj]

Not much to go on, but some general thoughts:

On your 7 "data sheets"
* Organize your data by dates across the top and categories down the side
- Let's say your dates are in cells B1 to Z1
- Let's say your category are in cells A2 to A100

* Your summary page then becomes a report template to pull info from the data sheets
- Put a date in cell B1
- Put a category in cell A2
- In cell B2 "=sumproduct((DataSheet1!$B$1:$Z$1=$B$1)*(DataSheet1!$A$2:$A$100=$A2)*(DataSheet1!$B$2:$Z$100))
- Continue this pattern by adding more categories and / or with other columns having different dates, or pulling from a different data tab, etc.

Notes: The formula finds the date that is on your summary tab in the list of dates on your data tab AND finds the category the same way. Where those two intersect in your data tab table, that number is returned.

This may at least spark an understanding (it isn't an easy concept), and set you on your way.

Jeff

 

[jdwoods]

To further explain this what the data pages look like
there are 15 columns on the main data page, now only 5 columns need to be transfered to the summary page, Data is not enetered until row 4 and will continue until row 13 but row 14, 15, 16, 17 has data that does not need to be transferred but row 18 until row 27 and then there will be 5 rows that do no tneed data transferred. All the data in Row 3 in All Columns are Label or Title for what goes in the cells below
Here is kind what the data page looks like and the seven sheets represent the days of the week, this is an inventory control.
column A Column B Column C Column D Column E Column F
Row 3 Commodity Date B.L. # Container # Seal # # of Bags
Row 4 101-2Z 08/010/11 XP00001 CNRU111111 000001 500
So i want row 4 to transfer as it is entered I hope this is a little more explation

 

[jdwoods]

Doublej_jj i tired your suggestion but coul not get to work, nothing happened at all.