Sorry for the late response....see below for my answers.. Thanks again for your help!



Quote Originally Posted by rcm View Post
OK. Let me ask questions..
like I said the code is very simplistic so I may have to twick it a bit

Are the fields in file1 thru file4 the actual fields that you want to transfer using the real data? --- Yes
Is the order of the fields exactly as posted in the example? -- Yes (but what if I needed to change the order of the fields, would I be able to manage that too with a couple of minor changes in the code?)
Is Main the only source of information? --- Yes
Is this a repetitive action or is it once and done? --- Repetitive would be ideal; however if I can do it for say 100 entries at a time, clear the Main file and then load it again with more entries, if that is easier to do?

I´m asking all of these questions because the sample file are filled with the macro posted...but your real data might have another structure