Autofill query

[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

 

[Andy B]

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

 

[Dave Peterson]

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.