Hi Good People.
I have an excel workbook with 5 different work sheets. First work sheet is the Master sheet and others are customer data sheets . I want a VBA loop to go through all 4 customer data sheets >> then copy a specific range in each individual sheets >> paste it to master sheet.
However it does not simple as it sounds because data stored in very un structured way. I have attached my workbook below and I have mentioned my expected outcome on it. Kindly check and help me to find a work around for this. Thank you very much.
I have an excel workbook with 5 different work sheets. First work sheet is the Master sheet and others are customer data sheets . I want a VBA loop to go through all 4 customer data sheets >> then copy a specific range in each individual sheets >> paste it to master sheet.
However it does not simple as it sounds because data stored in very un structured way. I have attached my workbook below and I have mentioned my expected outcome on it. Kindly check and help me to find a work around for this. Thank you very much.
My workbook.xlsx
Master Sheet 03/01/2022 Customer1,Product Name,Price Gatorade,4.97 Oak,9.52 Joe's Classics,5.48,THE YELLOW HIGHLIGHTED RANGES ARE FIXED RANGES. EACH CUSTOMER HAS AN UNIQUE NUMBER OF ROWS Joe's Classics,6.48 Joe's Classics,7.48 Joe's Classics,8.48 Joe's Classics,9.48 This is the output I need 03...
docs.google.com