Merging Separate Worksheets into one Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 90 separate Excel files each with one worksheet. I can manually
open these and move each worksheet into a master file but this is time
consuming. Is there an easier way to move all these files into one workbook
so that I end up with only one file containing 90 individual worksheets?

I am doing this at work so I am not sure if I am allowed to copy macros for
security purposes. In addition, I am not very familiar with macros but need
to learn. If someone knows of standard Excel commands to do this (maybe an
add-in) that would be great. Otherwise, I welcome all suggestions.

Sincerely,
Jim
 

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
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Merge Multiple Single Worksheet Excel Files into one file in separ 4
Linking multiple worksheets in one workbook 2
Collate Worksheets into single workbook 3
Help on consolidate worksheets from different workbooks into one 2
Merge worksheets from separate files into one workbook. 7
how can I combine multiple worksheets into a single workbook? 5

Back
Top