I am trying to figure out how to do this macro i am not familiar with this type of programming
i have some xls files they have fields inside and i want to copy from each file same field and put in one xls file in row they all are in sheet1
example
File 1
Description Name ID Intel David 245
---------------------------------------
File 2
---------------------------------------
Description Name ID Intel 2 David 2 246
File 3
---------------------------------------
Description Name ID Intel 3 David 3 2467
there are a 9000 files like this all what i am looking to do in one file is >
Description Name ID Intel David 245 Intel 2 David 2 246 Intel 3 David 3 2467
etc...
Thanks if some one can help me with this
Bookmarks