MattToner
asked on
Pulling data from different spreadsheets
Hi,
I hope someone can help.
We currently have jobs completed on a spreadsheet, it essentially have simple information such as name, address, number, description, etc. Once the form is completed, it is all saved within a folder. These files are are saved under the format Name and Date, ie JoeBloggs29102015.xlsx
Is there a way, I can have a master spreadsheet which will automatically scan the folder and list the information in those individual spreadsheets and place it into the master spreadsheet?
I've provided some sample data to show what I mean.
Thanks
Master-Data.xlsx
JoeBloggs29102015.xlsx
I hope someone can help.
We currently have jobs completed on a spreadsheet, it essentially have simple information such as name, address, number, description, etc. Once the form is completed, it is all saved within a folder. These files are are saved under the format Name and Date, ie JoeBloggs29102015.xlsx
Is there a way, I can have a master spreadsheet which will automatically scan the folder and list the information in those individual spreadsheets and place it into the master spreadsheet?
I've provided some sample data to show what I mean.
Thanks
Master-Data.xlsx
JoeBloggs29102015.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER