Forum Discussion
Copying sequential values between worksheets
Hi I would like to copy column total figures (totals in image 1 in yellow) from one worksheet (horizontal) to a column on a different worksheet (image 2). I would like to copy L47, M47, N47 etc. I h...
My apologies, I forgot to include a reference to the other sheet in the formula..
Change the formula to
=TRANSPOSE('W1'!L47:P47)
where W1 is the name of the other sheet.
I did wonder about the reference to the other worksheet! Thanks so much, it has worked.
Louisa
Louisa