Link to home
Start Free TrialLog in
Avatar of MattToner
MattTonerFlag for United Kingdom of Great Britain and Northern Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MattToner

ASKER

Thank you very much for that, exactly what I needed.