Hi all,
I was hoping to get some advice regarding merging data from different worksheets in Excel 2010.
I currently have a workbook with around ~500 individual sheets, each containing a single column of data, where the sheet title is the name of each column of data (eg. the title of the first sheet is Pt101 and contains data from participant 101). I would like to merge the sheets into a single sheet, with each column separate (ie. Pt1 would be in column A, Pt2 would be in column B etc). Ideally I was also hoping to have the sheet title as the header row as well. I've included a sample of the data, and an example of what I was hoping to get in the end.
Searching on this has pretty much just brought me to the 'consolidate' option, however I don't think this achieves what I was after. I'm also pretty new to VBA.
I was wondering if anyone had any suggestions on how to do this, or even whether it is possible.
Any advice/assistance would be greatly appreciated!
Thank you
I was hoping to get some advice regarding merging data from different worksheets in Excel 2010.
I currently have a workbook with around ~500 individual sheets, each containing a single column of data, where the sheet title is the name of each column of data (eg. the title of the first sheet is Pt101 and contains data from participant 101). I would like to merge the sheets into a single sheet, with each column separate (ie. Pt1 would be in column A, Pt2 would be in column B etc). Ideally I was also hoping to have the sheet title as the header row as well. I've included a sample of the data, and an example of what I was hoping to get in the end.
Searching on this has pretty much just brought me to the 'consolidate' option, however I don't think this achieves what I was after. I'm also pretty new to VBA.
I was wondering if anyone had any suggestions on how to do this, or even whether it is possible.
Any advice/assistance would be greatly appreciated!
Thank you
Excel 2010 | |||
---|---|---|---|
D | |||
18 | |||
Pt1 |