What would insert automatically?

The column?

Type the date in any cell and that date would stay there?

Or go into the new column?

Into which cell in the new column?

What is the "main date cell"?

I'm struggling here as you can see.

Can we give him a macro which he can trigger with a button or shortcut key to
insert a new column and enter the date?

Sub Insert_Enter()
Selection.EntireColumn.Insert
ActiveCell.Value = Format(Now, "dd mmm yyyy")
End Sub

This will insert a column and enter in the active cell.


Gord Dibben MS Excel MVP



On Thu, 17 Aug 2006 12:54:01 -0700, Tara wrote:

Gord,
One of the managers brought this to my attention. He is currently inserting
the column & date manually but I believe there is a lot of data input each
day and he would like to be able to just type the date in any cell and it
would insert automatically. It is my understanding it would go just to the
right of the main date cell. I hope this helps.
Tara

"Gord Dibben" wrote:

Tara

To do what you want would require VBA code of some sort.

Where/how would the new date be typed in?

Where would the new column be inserted?

Why not just insert a new column and type the date in that column?


Gord Dibben MS Excel MVP




On Thu, 17 Aug 2006 08:41:02 -0700, Tara wrote:

I have a spreadsheet that has several columns with dates - Today's date,
yesterday's date, etc. If a new date is typed in, how can I set the
spreadsheet to automatically insert a column for the new date?