Can I combine 100+ sheets from different workbooks into one worksheet?

M

Michelle

I am trying to combine data for 100+ employees, each employee's
information in one sheet of one workbook (thus all separate files).
The column heading's for each employee's sheet are the same. So
basically I want to have one master spreadsheet with data for all
employees on it. Is it possible to consolidate this data from 100+
separate files?
Please help! Thanks in advance!

- Michelle
 
G

Guest

Michelle.

You might also want to look at something like Boardwalk from Boardwalktech--
it's a solution for consolidating information from multiple spreadsheets and
then managing changes as they happen. I have been helping them out on the
sales & marketing side and HR applications are a good fit.
 

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

Merge Multiple workbook sheets into one workbook 0
How to combine data from 100 similar Excel files 2
how do i combine data from multiple sheets into one sheet? 3
Join workbooks 3
Multiple workbooks to one worksheet 3
combine several workbooks without opening 4
consolidate workbooks to worksheets in one workbook? 1
linking many workbooks 6

Top