Forum Discussion
How Do I auto-populate cells in a master workbook by referencing cells in other workbooks that have
I have a master workbook that I do not want anyone touching. I parsed the data from the master across 3 separate workbooks. Each of the 3 team members has one of these excel workbooks. When they make...
Hi Junuh
Please let me rephrase and understand your query correctly.
1. You have master workbook with separate sheet for each user
2. You wish to populate the information into one mastersheet.
If that is the case then you use Power Query to get all the information into one sheet by using the Power Query Function
=Excel.CurrentWorkbook()
This video link might be helpful : https://youtu.be/F5fjv6nXvZo
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert