How to merge 10 files in one step?

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
 
J

Jim Rech

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.
 
Top