I have a weekly production sheet and want it to put the date in
automatically when i enter the production info.

So on the first day it would put the date in, and on the next day it
would put that date in.

Its so i can put the week day in to calculate weekly production.

Is this possible or am i just been lazy.

Any help would be much apprecieated.

cheers

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918

Just had a thourght.

Can you have mondays date of that week put into the first row as soon
as the file is opened that week?

I could then have it work out the rest of the week.

cheers

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918

cs2883 wrote:
I have a weekly production sheet and want it to put the date in
automatically when i enter the production info.

So on the first day it would put the date in, and on the next day it
would put that date in.

Its so i can put the week day in to calculate weekly production.

Is this possible or am i just been lazy.

Any help would be much apprecieated.

cheers

Ian


Not exactly what you asked but will this work?

Insert a static date or time

Current date Select a cell and press CTRL+;

Current time Select a cell and press CTRL+SHIFT+;

Current date and time Select a cell and press CTRL+; then SPACE then
CTRL+SHIFT+;

thanks, i'm ever hopeful of a lazy way of doing it.

regards

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918

Ian

If your data is being entered in column A and you want a date stuck into
column B use this event code.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in a cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("A" & n).Value < "" Then
Excel.Range("B" & n).Value = Date
End If
End If
enditall:
Application.EnableEvents = True
End Sub

This is worksheet event code.

Right-click on the sheet tab and "View Code". Copy/paste the code into the
module.


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 15:32:37 -0500, cs2883
wrote:


I have a weekly production sheet and want it to put the date in
automatically when i enter the production info.

So on the first day it would put the date in, and on the next day it
would put that date in.

Its so i can put the week day in to calculate weekly production.

Is this possible or am i just been lazy.

Any help would be much apprecieated.

cheers

Ian

cheers, ill have a go with that and let you know how i go.

regards

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918

Ok, i'm really new to all this. What exactly do i have to do with that.
I've tried to put it in as a macro. Is that right? If not what do i
do?

Sorrry to be a pain!

cheers in advance

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918

Its ok, i got the idea of how to do it from another post.

This forum is ace!!

cheers

Ian


--
cs2883
------------------------------------------------------------------------
cs2883's Profile: http://www.excelforum.com/member.php...o&userid=27888
View this thread: http://www.excelforum.com/showthread...hreadid=473918