how do I merge data from separate spreadsheets

G

Gary Milks

I have 4 separate spreadsheets with "sales lead" information. I would like
to merge the information from the 4 spreadsheets into a consolidated sheet.
All spreadsheets have the same column information. Manually, this is easy
with cut and paste, however, I would like this automated. So in the
"summary" spreadsheet, I would like it to open each of the others, bring in
their data, then sort by the first column.
I have been successful showing a window to the other spreadsheets, however,
this does not allow for any data manipulation.

Thank you for any help you can provide.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Page numbering with Merged Document and IF statements 1
How to paste the same cell one tab over 1
merging spreadsheet data 1
How to extract data from a spreadsheet into a form/create form from spreadsheet data 3
How do I consolidate data from several spreadsheets into one. 4
Emailing mail merge templates 0
merging spreadsheets 2

Top