Thread: Drag-fill skipping a lot of rows

Hi PS Dude,

Take a look at the formulas I used on the September sheet, cells A2:B2 (merged) and B3:B13. I changed the simple reference formulas to INDIRECT formulas, so you can manipulate how many rows to advance when copying the formulas downward. For example, to get the value for A2:B2, I used:

=INDIRECT("'Paste Export Temp Here'!A"&CEILING((ROW()-1)/12,1)+1)

Which takes the current row (2), subtracts 1 to get 1, then divides that by 12 to get a decimal number. This decimal is then rounded up to the nearest whole number and then I add 1 at the end because the data in Paste Export Temp Here starts in the second row, not the first. Because 1/12 through 12/12 round up to 1, and 13/12 through 24/12 round up to 2, this results in referencing row 2 for rows 2-13 (1-12 when 1 is subtracted initially) and 3 for rows 14-25 (13-24 when 1 is subtracted initially).

Somewhat confusing, but seems to work when the formulas are copied from, say, A14:B25 down to A26:B37. Because of the merged cell(s) I wasn't able to drag the formulas down, but I could select A14:B25 and copy, then select A26 and choose Edit -> PasteSpecial -> Formulas.

Hope that helps!

One other note:

In your original file, on the "Paste Export Temp Here" sheet you had "Hedda Lettus" while on the "Paste Logs Here" sheet you had "Hedda Luttus". For obvious reasons the formulas would not find a match, so I changed the"Luttus" to "Lettus" on the Logs sheet.