Log In
Register
Home
July 12, 2020
Offline
Dear All,
I have attached an sample excel file in which I have 5 sheets
MASTER SHEET - This is where all the Data is.
DAILY SPORTS
GODS GRACE COMPUTER
JOY OF LIFE
RODNEY ENTERPRISES
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,
Subash SD
VIP
Trusted Members
December 7, 2016
Offline
Hello,
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.
Br,
Anders
July 16, 2010
Offline
Hi Subash,
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.
Mynda
1 Guest(s)
