Hello everyone,
I've got an excel workbook with 2 sheets, each sheet pulls a dynamic SAP report using their add-on
On sheet1 I've got the revenues for company one, and on sheet2 for company 2
The format is:
Sales Unit/Company/Project/Customer then followed by monthly revenues
Is it possible to consolidate/merge both reports in sheet3, while preserving the grouping by Sales Unit then company?
So I'd like to have in sheet 3
Sales Unit 1 company 1 rest of data
Sales Unit 1 company 2 rest of data
Sales Unit 2 company 1 rest of data
Sales Unit 2 Company 2 rest of data
etc...
All the while taking into consideration that the data is dynamic, and records may vary after refresh.
I've attached a couple of screenshots if that helps, but couldn't install the add-on for now to upload a sample file.
I've got an excel workbook with 2 sheets, each sheet pulls a dynamic SAP report using their add-on
On sheet1 I've got the revenues for company one, and on sheet2 for company 2
The format is:
Sales Unit/Company/Project/Customer then followed by monthly revenues
Is it possible to consolidate/merge both reports in sheet3, while preserving the grouping by Sales Unit then company?
So I'd like to have in sheet 3
Sales Unit 1 company 1 rest of data
Sales Unit 1 company 2 rest of data
Sales Unit 2 company 1 rest of data
Sales Unit 2 Company 2 rest of data
etc...
All the while taking into consideration that the data is dynamic, and records may vary after refresh.
I've attached a couple of screenshots if that helps, but couldn't install the add-on for now to upload a sample file.