Hi
I want to merge the data on specific columns on different worksheets and combine into one excel file. I have added an attachment which shows what I want to do.
I have around 260 worksheets and want to combine the data from columns merge columns.xlsx. In this example I have 3 worksheets. Sheet4 and sheet5 have data sets and sheet1 has what I want. I just want to combine the data in columns G to columns L continuous. It it was for some worksheets I would have manually done that. But I want to merge the data from 260 worksheets so I am looking for a macro or some efficient way to do it.
Thank you so much for your help.
Jd
Bookmarks