Forum Discussion

MikeD760's avatar
MikeD760
Copper Contributor
Nov 02, 2021
Solved

Referencing a Row Number

I am trying to use the text data entered on Sheet 1 and re-use it as text in Sheet2.

 

Text in Sheet1, Row 2 is rearranged to a nice formatted display on Sheet 2. I can do this by entering 

='Sheet1'!B2 and as needed for other fields.  Using this for data in A2, B2, C2, D2, E2, F2.

I am using CONCATENATE to put text strings together in some cells.

I would like to have a Cell that I can put a number in, and that number represents the Row Number in Sheet 1.   For Example - put a 4 in the Cell & then the Sheet 2 fields use data from Row 4 on Sheet1.

 

='Sheet1'!B2 and as needed for other fields.  Using this for data in A2, B2, C2, D2, E2, F2.

Enter Number 4  and all the data matches basically becomes

='Sheet1'!B4 and uses data from A4, B4, C4, D4, E4, F4.

 

 

 

6 Replies

Resources