how do I merge data from separate spreadsheets

G

Guest

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

How do I match and append/merge data from two spreadsheets? 2
How do I consolidate data from several spreadsheets into one. 4
merging two large spreadsheets 2
merging spreadsheets/one has extra space in each cell 2
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
.net formatting data in excel 2
Connecting information on different spreadsheets 1
How can I automate copying data from one into several spreadsheets 2

Top