Importing Data from Multiple Excel Documents Into a Single File (take 2)

Hi,
I used the suggested macro from this post here to fix a problem that I had:
http://www.excelforum.com/excel-gene...html?p=3022404

Now I have another project where I need to merge several files but instead of rows of data like in the linked discussion above, the data is in column format. I tried to modify the macro for columns but my knowledge of the macro language is a bit limited (for now anyway ;-) )

Below is the VBA code suggested by stanleydgromjr from the above link. I like the way this macro is written. It's an elegant approach to the problem. I'd like to have some pointers on how I can modify this code to copy columns instead of rows.

Please Login or Register  to view this content.

Thanks,

Thanks for the link. Those macros are a little more complex then the one I posted above but I managed to make one of them working.

Great help to me too!

Thanks a lot!