- Joined
- Dec 22, 2009
- Messages
- 1
- Reaction score
- 0
Hi,
I am newbie to excel programming and need help with a basic code.
I have 2 workbooks( Book1 and Book2) with multiple sheets.
I am only interested in one of the worksheets in the workbooks(both the worksheets names are the same).
The thing is that the data is in the form of pivot tables, so each time i have to filter according to specific categories, copy and paste into another new workbook.
The thing is column headings in both the worksheets are different,BUT BOTH the worksheets data must be combined into 1 single worksheet( row after row).
Meaning in Book1, my columns are in the form of Cost, revenue,margin
and in book2, the columns are in the form of Cost,Revenue, Profit Margin %....
That means i must add a profit margin % column in Book1 and a Margin column in Book2 before I combine the data into a single worksheet...
Each week, new data gets added into Book1 and Book2, so I wish to automate this by creating a code, so that when the source data changes, my new workbook's data also changes..
Can someone please help me with a sample code or something that will do that?
Thank you very much!!
I am newbie to excel programming and need help with a basic code.
I have 2 workbooks( Book1 and Book2) with multiple sheets.
I am only interested in one of the worksheets in the workbooks(both the worksheets names are the same).
The thing is that the data is in the form of pivot tables, so each time i have to filter according to specific categories, copy and paste into another new workbook.
The thing is column headings in both the worksheets are different,BUT BOTH the worksheets data must be combined into 1 single worksheet( row after row).
Meaning in Book1, my columns are in the form of Cost, revenue,margin
and in book2, the columns are in the form of Cost,Revenue, Profit Margin %....
That means i must add a profit margin % column in Book1 and a Margin column in Book2 before I combine the data into a single worksheet...
Each week, new data gets added into Book1 and Book2, so I wish to automate this by creating a code, so that when the source data changes, my new workbook's data also changes..
Can someone please help me with a sample code or something that will do that?
Thank you very much!!
Last edited: