Automatic update of spreadsheet & automatic update between workboo
 

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Automatic update of spreadsheet & automatic update between workboo
 

See Excel's Help on "Create a link to another cell, workbook, or program"

You can link one cell to another in the same sheet, a different sheet or a
different workbook.

Note the info on "updating links" between workbooks.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 08:45:01 -0800, Losva
wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Automatic update of spreadsheet & automatic update between wor
 

Try This simple excercise and see if it does what you are asking..

In your cell type the equals symbol, then click on the cell on the page you
are asking for the total to be placed and then hit return.

"Gord Dibben" wrote:

See Excel's Help on "Create a link to another cell, workbook, or program"

You can link one cell to another in the same sheet, a different sheet or a
different workbook.

Note the info on "updating links" between workbooks.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 08:45:01 -0800, Losva
wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Automatic update of spreadsheet & automatic update between wor
 

Hi Gord Dibben,

Thank you for your tip, I just have one problem though... I'm working for a
Dutch company and therefor only have the Dutch version, which I really dont
understand that well yet :p

But I'll see if one of my colleges can give me a hand for now:)

Thanxs again!

"Gord Dibben" wrote:

See Excel's Help on "Create a link to another cell, workbook, or program"

You can link one cell to another in the same sheet, a different sheet or a
different workbook.

Note the info on "updating links" between workbooks.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 08:45:01 -0800, Losva
wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Automatic update of spreadsheet & automatic update between wor
 

Hi there!

Thanxs for the tip! I'm using "your" method as of now, until I manage to
find a way to do this a bit more efficient... ( There is a H*** of a-lot of =
+ cellnr. I have to put in you see... try 365 x 7 x 10 :p )

I apreciate your help though ;)

"Bar Charts With =sum ... showing Zero" wrote:

Try This simple excercise and see if it does what you are asking..

In your cell type the equals symbol, then click on the cell on the page you
are asking for the total to be placed and then hit return.

"Gord Dibben" wrote:

See Excel's Help on "Create a link to another cell, workbook, or program"

You can link one cell to another in the same sheet, a different sheet or a
different workbook.

Note the info on "updating links" between workbooks.


Gord Dibben MS Excel MVP

On Thu, 7 Dec 2006 08:45:01 -0800, Losva
wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Required formula
 

hi,
i am working on the excel sheet everyday i need a solution that would save
my time Question as below
In Excel.
A B C D E
F G
start time End time Client Customer
1 ? ? ANN JACK 09/11/08
0911/08
2
3
4
5
Whenever i enter ANN in Column "C1" the column "A1" should show the current
time of the system as start time, as so on When i key JACK in column "D1" the
column "B1" should show the current time as end time. so number of enteries
are made so need to save the time i need a formula.
--
vijay


"Losva" wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!

Required formula
 

vijay,

You need to use a worksheet event. Copy the code below, right-click the sheet tab, select "View
Code" and paste the code into the window that appears. The code will but the time into either
column A or B, and the date into E or F (not sure why you included G).

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Intersect(Target, Range("C:D")) Is Nothing Then Exit Sub
Application.EnableEvents = False
With Target(1, -1)
.Value = Time
.NumberFormat = "hh:mm"
End With
With Target(1, 3)
.Value = Date
.NumberFormat = "mm/dd/yy"
End With
Application.EnableEvents = True
End Sub



"vijay" wrote in message
...
hi,
i am working on the excel sheet everyday i need a solution that would save
my time Question as below
In Excel.
A B C D E
F G
start time End time Client Customer
1 ? ? ANN JACK 09/11/08
0911/08
2
3
4
5
Whenever i enter ANN in Column "C1" the column "A1" should show the current
time of the system as start time, as so on When i key JACK in column "D1" the
column "B1" should show the current time as end time. so number of enteries
are made so need to save the time i need a formula.
--
vijay


"Losva" wrote:

I am doing a survey on a monthly basis. I have one sheet for each day and one
sheet for the output data from each day. I want to know if there is a way for
me to have the "output sheet" update automaticly as I enter data on the "day
sheets" ?

And question number two: Is there a way to get a separate workbook to update
automaticly with the data I enter in other workbooks?

I'm not the most experienced Excel-user so any explanations/help posted
shoud be very step-by-step...

Would apreciate any help or hints of where I can find answer to these
questions!