Forum Discussion
Re: Copying sequential values between worksheets
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.
1 Reply
- I did wonder about the reference to the other worksheet! Thanks so much, it has worked.
Louisa
