How do I write the code so when i highlight the field with the formula and drag it accoss the cells, the link to column A stays the same and the rows increment by one....
=Sheet1!A3
I'm sure i have to place a dollar sign somewhere but I dont know how, i've tried all the variable possible...
Bookmarks