create an autofill series!
 

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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=522759

create an autofill series!
 

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)

via135 wrote:

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

--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=522759

--

Dave Peterson

create an autofill series!
 

thks Dave!

your method works perfect!!

thks again!

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=522759