Forum Discussion
surfmunk
Dec 06, 2020Copper Contributor
How to referencing names on Sheet 1, column A on Sheet 2, row 4
Hi, I have a list of names in Sheet 1, column A. On Sheet 2, I'd like to reference names in Sheet 1 but in row 4. It is not a fixed set of names so I am not sure Transpose is the right path here....
adversi
Dec 06, 2020Iron Contributor
The shortcut is to create a named range and Transposing by selecting the row to make it a real-time update: