OK, I'm not sure how to ask this question...
How do I summarize dynamic ranges of data to a new sheet?
For example on sheet1 I might have...
A B C
1 x x x
2 x x x
3 x x x
and on sheet2 I might have...
A B C
1 o o o
2 o o o
3 o o o
and these ranges are dynamic, meaning they could be more or less rows (columns are static)
I would like to have a summary sheet showing the 2 ranges combined sequentially like so...
A B C
1 x x x
2 x x x
3 x x x
4 o o o
5 o o o
6 o o o
is there any way to do this?
I have searched online, but haven't found an answer, mainly because I'm not sure exactly how to phrase my search.
Any help would be greatly appreciated!
Bookmarks