Combining Spreadsheets

[ylolablvr]

I was wondering if it is possible to take two excel spreadsheets and pull data from one to be automaticly enterened into the other depending on the heading. I am not sure if this explains my question so let me give you an example. I have a report in quickbooks that I can export to excel. In this report I have several differnt classes with items in each class. I would like to be able to pull the total from those classes and have it go to a summary spreadsheet. Is this possible and if so where can start to learn how to do this? I am thinking I should be able to do it with formulas or programming but I am not really certain. Any help is greatly appreciated!

[Pepe Le Mokko]

Perhaps Data consolidation or a Pivot Table?

[arlu1201]

You can do it with a macro as well. Why dont you upload a sample file with some instructions on what you want to be done.

[ylolablvr]

HRS TOTAL MASTER.xlsxexcel help sheet #1.xlsx
Ok I hope I uploaded them correctly. I need to take the totals from spreadsheet #1 and put them into the appropiate space in the totals spreadsheet. I also must add that spreadsheet #1 will change often so I would need it to recognize the job# and put it in that row. You will notice that on #1 it say mat after some of them this is the material items the others are Time(labor). I hope I explained this correctly.

[arlu1201]

It will be good if you attach a sample output file to show us how you want the data and also how you obtain it.