I have a list containing customer data.. can I insert a date automatically?

Hello.

I have a spreadsheet which I am trying to use to capture customer data. What I want to happen is whenever I enter a new record, the date appears automatically in a Date column.

eg.

.......A............................B............................C.....
CompanyName_____CompanyPhone_______Date


Whenever I put a record into the first and second column, the date appears in column C.

I wat it to work a bit like Autonumber in Access if you see what I mean.

I hope this i enough info, please go easy on me as I am not an advanced user.

Do you want the column C to fill with the current date automatically
You need a VBA code.
or easier way, you can use shortcut: (Ctrl +

Paste this into the sheet's code (right click sheet tab - view code)

Please Login or Register  to view this content.

I set it to add a date on input to Column 1 (A) except for row 1. We can make the parameters for what calls this macro as specific as you like but I think this might be all you need.

Also, this will "hose" any existing entries in Column C - would you prefer it to overwrite automatically or not?

HTH

The "overwrite" mode could be turned off by replacing this line of code:

Please Login or Register  to view this content.

(sure you can guess where...)