Excel Help to copy information from one row at a time to another sheet

L

LizD

Joined
Dec 14, 2022
Messages
1
Reaction score
0
Hi
I'm trying to copy info - in various columns from one row - then change the row but keep the columns?
See below snip - what formula should I enter into B8 so that it copies the data for person 2, so B3...
I had thought I could so something like =B(=B7) so I could change the value in B7 to quickly give me the data of each row in turn.
Is there a quick way to do this, rather than changing all my formulas (=B3; =C3 =D3, =E3 etc.....is there some way I could just type in 3 to give me the row position that I want)
Obviously this is a simplified version of what I really want but I hope you can understand from this?
Thanks in advance
1671030418987.webp
 
Hello
There is an indirect function in Excel. I have actually never used it myself, but, I just tried it to do exactly what you are asking. It seems to do what you were thinking with the =B(=B7) idea that you had.

Example:
In the test example you showed, type this in cell B8 and see what happens
=INDIRECT("B"&B7)

The way it seems to work is that within the ( ) you build up the string of the cell reference that you want. You use the similar rules that you normally use to build up a text in a cell: Like if you wrote in any cell
="B"&B7
, then in the cell you would then see for you example data
B3

Alan
https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261
 
Last edited:
Back
Top