merging certain cells with bunch of files

[Roy123]

Hi,

I have bunch of different identical files with the same format and number of cells, each have 2 columns A and B, with 200 rows. I like to copy those 2 columns in all of my files (about a 100) and lay them side by side in one file...

so in my master file I want to copy the first file to columns A and B, my second file to column C and D, my third file to column E and F and so on...

What is the fastest way to do this?

Thanks so much for your help.

[fdservices]

User simple formulas in the Master File:

eg

A1: "=[ClientFile1]Sheet1!$A1"
B1: "=[ClientFile1]Sheet1!$B1"
C1: "=[ClientFile2]Sheet1!$A1"
D1: "=[ClientFile2]Sheet1!$B1"
E1: "=[ClientFile3]Sheet1!$A1"
F1: "=[ClientFile3]Sheet1!$B1"

You can speed up the process of making the master file by careful use of Cut and Paste and Search and Replace

All the best

Andrew

[Roy123]

thanks for your reply, is there a software that I can put all my files in it that can automaticaly do this for me? If I do it one by one, its gona take me hours to do this, I have lots of files

thanks

[fdservices]

You might be able to write a macro to do it by reading the file names from the directory and creating the formulas across the page.

Andrew