July 12, 2020
I have attached an sample excel file in which I have 5 sheets
MASTER SHEET - This is where all the Data is.
GODS GRACE COMPUTER
JOY OF LIFE
I request for a formula, NOT VBA, to be input in each client's sheet, which would transfer the data of each client to their respective sheet once their name is input in Column B (heading CLIENT) of the MasterSheet.
Presently I am filtering data and copy pasting into each sheet.
My actual workbook has about 100 sheets. You can imagine the time consumed to transfer the data.
Kindly assist. I Thank everyone in advance.
Thanks and best regards,
December 7, 2016
In my view the Pivot Table solution is better than a formula based, but in attached file you will see an example of the two solutions.
The helper column in the Master table is there only to assist the formula based solution using VLOOKUP.
I trust you look through the examples given to see how I have done, else just shout out and I (or someone else) can explain in more details.
July 16, 2010
I agree with Anders. PivotTables is definitely the way to go as they're much more robust. Formula solutions like this will inevitably break or be littered with errors.
You can auto-generate the PivotTables using this simple technique. And then to maintain/update them it's just a click of the Refresh All button on the Data tab of the ribbon.