Forum Discussion
Create individual Excel spreadsheets with the data from a master file
Hi Excel-Pros, I have a large Excel spreadsheet (Master File) with different customer names and their yearly turnover. I have another Excel spreadsheet (Calculator) which calculates sales bonus a...
I would copy your calc sheet to the file with the data and then use a function like XLOOKUP (in the Calculator sheet) to fetch data from the master file into the calculator sheet.
- That´s a good idea, thanks.
However, each of the different customers shall receive his own calulator spreadsheet so after Xlookup, the calculator must be saved as an individual file with the customers name in it and the data of all other customers must not be part of the list anymore.
Is there any way to realise this?
