I have an Excel File that contains 2 sheets. Sheet 1 name = List, Sheet 2 name = Form
I would like to set up a formula on my Sheet named Form, that references the Activecell.Row on the List Sheet
I have tried numerous ways but can't seem to remember the formula from years ago
I have used =List!Activecell.row.column1 and numerous other ways, can someone please refresh my memory.
Thank You in advance
I would like to set up a formula on my Sheet named Form, that references the Activecell.Row on the List Sheet
I have tried numerous ways but can't seem to remember the formula from years ago
I have used =List!Activecell.row.column1 and numerous other ways, can someone please refresh my memory.
Thank You in advance