Hi. I set up a worksheet with the first column for dates, and the 5th column
for invoice numbers. I do not always have an invoice number for certain
items so I type the date instead. I am wondering if there is a formula to
have exel automatically copy the date in the date column to the invoice
column for each row I type so it will eliminate the need to retype the date
over and over.

Thanks much!
joy