Automatically update cells
 

Hi all,

I am looking for help with the following problem.

I would like for two cells to automatically update every time I fill in
other cells.

For example:

Cell A1 is the date cell
Cell B1 is the weight cell

In column F, I have every date for a month and in column G, I insert a
weight

I would like for cell A1 to automatically update with the date from column F
and cell B1 to automatically update with the weight every time I enter a
weight into column G.

For example:

If column F has every date for a particular month, i.e. 1/3/06 in cell F1
and I enter 50.0 in cell G1, then cell A1 will reflect F1 (1/3/06) and B1
will reflect G1 (50.0). But when I enter 75.0 in cell G2 for the weight, I
would like for cell A1 to automatically update to 2/3/06 (F2) and cell B1 to
update to 75.0.

Is this possible.

Thanx in advance.

Maddoktor

Automatically update cells
 

You have a response at your other post in .excel.

Maddoktor wrote:

Hi all,

I am looking for help with the following problem.

I would like for two cells to automatically update every time I fill in
other cells.

For example:

Cell A1 is the date cell
Cell B1 is the weight cell

In column F, I have every date for a month and in column G, I insert a
weight

I would like for cell A1 to automatically update with the date from column F
and cell B1 to automatically update with the weight every time I enter a
weight into column G.

For example:

If column F has every date for a particular month, i.e. 1/3/06 in cell F1
and I enter 50.0 in cell G1, then cell A1 will reflect F1 (1/3/06) and B1
will reflect G1 (50.0). But when I enter 75.0 in cell G2 for the weight, I
would like for cell A1 to automatically update to 2/3/06 (F2) and cell B1 to
update to 75.0.

Is this possible.

Thanx in advance.

Maddoktor

--

Dave Peterson