Auto fill for dates?
 

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

Auto fill for dates?
 

Debra Dalgleish has some techniques:
http://www.contextures.com/xlDataEntry02.html

George wrote:

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

--

Dave Peterson

Auto fill for dates?
 

Thanks Dave,
your a champion

"Dave Peterson" wrote:

Debra Dalgleish has some techniques:
http://www.contextures.com/xlDataEntry02.html

George wrote:

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

--

Dave Peterson