ferocious12
Member
Hi All - I need to summarize the data from all the worksheets in a workbook (each worksheet represents 1 company data). Can you please help me with the code.
- structure of data is same in all worksheets
- data headers are in row six of each worksheet
- data starts from row 7 in each worksheet
- rows should be combined from each worksheet (company) upto the row upto the last value in column F or G
I want to combine data from all worksheets so I can create dashboard based on combined data for all the companies.
The summary worksheet will look like as below with combined data from all worksheets.
Thanks
- structure of data is same in all worksheets
- data headers are in row six of each worksheet
- data starts from row 7 in each worksheet
- rows should be combined from each worksheet (company) upto the row upto the last value in column F or G
I want to combine data from all worksheets so I can create dashboard based on combined data for all the companies.
The summary worksheet will look like as below with combined data from all worksheets.
Thanks