I am also looking for similar kind of macro to copy data from specific column of multiple sheets in single column of new workbook.
For example I have 1 workbook with 12 worksheets. Each sheet is having 50 columns with large data. All these sheets are having one common column. I want to collect the data of that common column from each sheet in new workbook in single column. Data should be collected one below other without header.
Is this kind of macro or vba code available?
Bookmarks