Hi all,
If you see the attached file, you will see a workbook with 46 sheets. The first one the "master file" is the one to add data and those data I want to be distributed in the other 45 sheets based on the agent name I have in the column A (the 45 sheets are named by the agent name). All sheets are similar.
Every day I will add more data in master file and all the sheets should be automatically updated...
I cannot use vlookup since the common column is the agent name and I have many rows by the same name.
Is it possible?
I saved the attachment as xlsx because it was too big..
If anyone can help me I will be grateful...
Bookmarks