I'm using two sheet and the second sheet is just a single column with multiple rows of a formula that references the first sheet. I can't figure out how to keep the single rows on the second sheet, but drag down the formulas using data on sheet one that doesn't follow that same pattern.
Sheet 1
Row 3 = data
Row 4 = n/a
Row 5 = n/a
...
Sheet 2
Row 1 = Formula using Sheet1!Row 3
Row 2 = Formula using Sheet1!Row 6
...
Here's the formula I'm using on Sheet 1, =IF(Sheet1!F3>1,(Sheet1!F3-1)*Sheet1!H3, 0), I'd like to be able copy/insert on sheet 1 when I require more data fields, but then just simply copy down on sheet 2 to grab the applicable data.
Many thanks!
Bookmarks