Auto fill for dates?

G

George

Hi,
I have a file that has the date in column A. The date is only listed in each
row where there is a new date, not in every row. I would like to fill all the
cells in Col A with the date for each transaction. e.g raw data below, please
help.
A B C
3/5/06 XYZ 123
ZZY 345
4/5/06 UUH 987
PPJ 654
JUJ 993
5/5/06 OUH 678

I need the dates in column A to appear on every row.
thanks
George
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to send email 5 days before a date mentioned in Cell 1
Refined Sort - Sort within a Sort 0
match one column with dates to several colums with dates, copy pas 4
copying_data_using_FillHandle 1
A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
insert new row every day. 2
Trying to change an Excel file to be database friendly 6
date corruption? 00/01/1900 2

Top