Forum Discussion

Copper Contributor

Apr 11, 2024

Solved

CELL REFERENCE

I have 2 sheets in 1 workbook. In the second sheet I use a cell reference to a cell in the first sheet(ie,DATA!G1). It works fine on the setup; however, when I change, copy an paste or delete the lin...

Formulas and Functions

Riny_van_Eekelen
Apr 11, 2024
JRDUBOVSKY
Perhaps this will work for you.
=INDEX(DATA!G:G,1)

Riny_van_Eekelen

Platinum Contributor

Apr 11, 2024

JRDUBOVSKY

Perhaps this will work for you.

=INDEX(DATA!G:G,1)

JRDUBOVSKY

Copper Contributor

Apr 13, 2024

Riny_van_Eekelen

THANK YOU!!! That code was perfect. Changed the second worksheet I now get the proper information from the 1st sheet.