Hi,
I hope this question has not been answered. I did search and found some similar questions but could not get any of the solutions to fit my exact situation.
What I want to do is take column 'A' and column 'B' from several worksheets and stack them together in a new worksheet.
IE
Sheet1
A B
-----
1 A
2 A
Sheet2
A B
-----
3 B
4 B
5 B
Sheet 3
A B
-----
6 C
7 C
Stacked into
Sheet4
A B
-----
1 A
2 A
3 B
4 B
5 B
6 C
7 C
Is this possible? I currently just copy and paste it of course but that gets old as we update the information in each sheet quite often.
Thanks in advance!
Michael Stinson
Bookmarks