How to merge 10 files in one step?

  • Thread starter Thread starter hce
  • Start date Start date
H

hce

Hi Everyone

I would like to check is it possible to merge 10 files with the same
format together with one step or less steps when compared to opening up
10 files and then copy and paste? I would really appreciate any help
given...

Cheers
 
There is no way built into Excel to do a merge other than copy/paste. (Well,
there is the Data, Consolidate command but I doubt it would do what you
want). People often write a macro to automate this sort of thing if they
have to do it repeatedly.
 

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

merging workbooks 1
Merge Like Files into 1 File 1
How can I merge data in several columns in Excel or Access? 3
Copy DVDs in Windows 10 5
From share drive particular excel file takes long time to open 0
How to Merge Files...? 1
Mail Merge Problem 1
Windows 10 Will Windows 10 be able to run on my PC? 3

Back
Top