Hi there. I'm having this problem with data that is scattered across several excel worksheets. There is lots of it. On the worksheet where I do all my calculations, i have no problem using built in formulas like average or stdev with the resulting big nasty range, like so:
but I need to find a way to copy all values from all of those ranges and paste them into one spot.
ie: could put that range into a macro and have it copy all of the referenced cells and paste all the values into one column.
Is this possible, or am I going to have to copy and paste one by one all of the data from each worksheet to a single place? (there are lots of data points).
Thanks a lot!
Kris
Bookmarks