Hello Good People
Just need a BIG help for a task. I have attached the Excel Sheet here.
I have multiple worksheets (Product1, Product 2, Product3 and new worksheets will be added as I add new products) and also have multiple sub categories (e.g. a Product has Multiple sub products and a Customer Group has multiple Sub Customer Groups which varies based on products, this will also extend/ change based on many/ few sub categories) .
I want to show all the tabs' information in one "Consolidated" tab where the rows and columns are dynamic based on Sub categories and number of rows.
If in the "Product" tab, any "Sub Product" or "Sub Customer" category is blank…then for the "Consolidated" tab, it should be filled by the previous category's description like those highlighted in green in the "Manual_Consolidated" tab.
I have done the "Manual_Consolidated" tab to show you guys what i want to accomplish in the "Macros_Consolidated" tab.
I hope i do not sound too confusing....happy to clarify again if needed.
Many thanks in advance for your kind help.