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