Forum Discussion
Copy Entire Column from Multiple Workbooks through Header Name and Paste Appended Result into Opened
I am looking for a code and i have looked around but could not find anything related. Thought to post a question here. I have multiple workbooks in a Folder around 8 and there are Similar columns...
Does it work if you change
wb.Columns(4).Copy twb.Sheets("Sheet1").Cells(1, Columns.Count).End(xlToLeft).Offset(, 1)
to
wb.Worksheets(1).Columns(4).Copy twb.Sheets("Sheet1").Cells(1, Columns.Count).End(xlToLeft).Offset(, 1)
Sir i am still looking for the help.
I hope that someone else can help you.