Hello
I have transposed two rows of a sheet using Paste Special but the cell-references change with the transpose. If I Paste Special with Link and the data moves, but if I try to transpose again, the cells change.
How may I keep the cell-references when I Transpose, please?
My workbook: Estimator.xlsx
Regards
Hi,
You'll need to tell us which rows on which sheet you are transposing, and manually add the results that you expect to see after the transpose telling us where the results list is shown.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
That's what I did in the end. I want the top row to be in the column starting B2.
I manually moved each row cell into its column cell.
Sorry but this is still not clear
Which sheet, which row, which cells?
And we also need to see what the ACTUAL output should be and know exactly where it is.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks