create an autofill series!

V

via135

hi all!

is there any method to create an autofill series for filling up the
following:

COL "A" COL "B"

03/01/2006 RECEIPT
03/01/2006 PAYMENT
03/02/2006 RECEIPT
03/02/2006 PAYMENT
.. ..
.. ..
.. ..
.. upto ..
03/31/2006 RECEIPT
03/31/2006 PAYMENT

-via135
 
D

Dave Peterson

I put this in A1:B2
03/01/2006 RECEIPT
03/01/2006 PAYMENT

I put these formulas in A3:A4:
=A1+1
=A2+1

And I put
RECEIPT In B3
and
PAYMENT In B4

I selected a3:B4 and dragged it down as far as I needed.

(Then I copied|paste special|values)
 
Top