Autofill query

  • Thread starter Thread starter diane
  • Start date Start date
D

diane

When using autofill on the following series, can I just
increment the quarter but leave the year intact?

Qtr1 02
Qtr2 02
QTR3 02
Qtr4 02
Qtr1 03
Qtr2 03
Qtr3 03
Qtr4 03

Thanks

Diane
 
diane

If you have a lot to do, I reckon your best bet would be to use two columns
of cells and join them after.

Andy
 
Another option is to use a formula:

="Qtr" & MOD(ROW(A1)-1,4)+1 & " " & TEXT(INT((ROW(A1)-1)/4)+2,"00")

and drag down.

then copy|paste special|Values if required.
 
Back
Top