Daniel,

Insert a new column B and enter in B2

=if(A2<"",A2,B1)

and drag that down to the end of your data, - then Copy the column and
Paste special = Values.
then delete the original column A



Daniel - Sydney Wrote:
Hi

Using Excel 2000 SP3.
I have a spreadsheet with two columns about 2,500 cells long.
A2 shows the date of the first purchase and B2 shows the cost,
B3 to B5 (say) show the cost of each transaction on that day but the
date is
not repeated in A.
A6 shows the date of the first transaction on that date and B6 the
cost
and so on, there is no consistancy in the number of transactions per
day.
I need to fill in the date of each transaction and dont want to do it
manually
by dragging the cell down as I have over 250 seperate dates on the
spreadsheet.

Is there a way to automate this?

thanks

Daniel


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=402019