Hello,
I have the following equation that I want to drag from cell 1 of a worksheet to cell 30.
=+'D:\Documents and Settings\218019778\Desktop\Accounts\Duxon (Melle)\Waste Treatment\Operator Log Sheet\[Operator Log Sheet Example.xlsx]Day 2'!$B$19
I want to keep the equation exactly the same in each cell I drag it to except that I want the Day (marked in red in the equation) to sequentially increase. For instance, I want the day to change to day 3, day 4, day 5, and so on as I drag the equation down.
Is this possible?
thanks!
Bookmarks