Hello all,
I have say 20 employees with their own individual excel workbook to enter data into. This file is saved on our server sharepoint.
I only want a portion of their spreadsheet to automatically upload into my master spreadsheet also on our server.
To be specific:
For my first employee, I would like the data from the individual sheet B3 to F42 (So columns B to F and rows 3 to 42) to upload into the Master sheet B3 to F42.
Then for the next employee I would like the data from the individual sheet B3 to F42 to go to the Master Sheet G3 to K42
and so on for all 20 employees.
I tried data connections and that didn't go too well - couldn't find connection.
I'm guessing I'll have to do a refresh on the mastersheet which is fine.
I'll include a picture of the individual and Masterfile.

Thank you
Individual File.PNG
Master Sheet.PNG