Forum Discussion

JRDUBOVSKY's avatar
JRDUBOVSKY
Copper Contributor
Apr 12, 2024

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's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 12, 2024

JRDUBOVSKY 

Perhaps this will work for you.

=INDEX(DATA!G:G,1)
  • JRDUBOVSKY's avatar
    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.

     

Share