I am trying to copy the cell data from another spreadsheet. The cells they are being copied into are in increments of three rows. The data I am copying from is only in increments of 1 row. The workbook I am copying from is named Sales. The worksheet is named March.
The function for the first cell (located at F4) is: ='[Sales.xls]MARCH'!$B2
I want the function for the 2nd cell (located at F7) to be: ='[Sales.xls]MARCH'!$B3
But if I drag the function, I get: ='[Sales.xls]MARCH'!$B5
What function can I use to set F7 equel to F4, but increment by 1 cell, instead of 3? What is the specific wording the function in my example?
Bookmarks