palm of thoughts
New Member
- Joined
- Jan 11, 2006
- Messages
- 14
Hi there!
I still have a problem with consolidation of workbooks.
Scenario:
I am working in HQ and at the end of each month, every branch under my care will submit an excel workbook to me. Inside this are two worksheets (worksheet 1 and worksheet 2 for convenience). Both have standard headers and rows and rows of data. Upon receipt, I will keep all these files in a folder called "Oct06" (and Nov06 etc for future mths)
Problem:
I'm not able to find an easy way to consolidate all the various worksheet 1 into one master worksheet. I need this so as to generate a pivot table. At the same time, I need to consolidate all the worksheet 2 also for the same purpose.
Hope anyone can offer me an easy way to resolve this problem. Thanks in advance for your kind act!
Rgds
P.O.T
I still have a problem with consolidation of workbooks.
Scenario:
I am working in HQ and at the end of each month, every branch under my care will submit an excel workbook to me. Inside this are two worksheets (worksheet 1 and worksheet 2 for convenience). Both have standard headers and rows and rows of data. Upon receipt, I will keep all these files in a folder called "Oct06" (and Nov06 etc for future mths)
Problem:
I'm not able to find an easy way to consolidate all the various worksheet 1 into one master worksheet. I need this so as to generate a pivot table. At the same time, I need to consolidate all the worksheet 2 also for the same purpose.
Hope anyone can offer me an easy way to resolve this problem. Thanks in advance for your kind act!
Rgds
P.O.T