I need to be able to record(keep) data from a number of cells on one
page to another page so that a user can go back and input other data at
a later date so as to be able to chart/ track the difference.

i.e. track by date
Cell D44 (Hrs Allocated dept 100)
Cell D45 (Hrs Allocated dept 101)
Cell D46 (Hrs Allocated dept 113)
Cell D47 (Hrs Allocated Dept 109)

The user will supply the date:

On a seperate work sheet a user will supply the hours used in each dept
and a formula will subtract Used from allocated to get the number that I
need.

Formulas already in place will fill in the numbers for the above cells.
I'm thinking some kind of form function. Any help or advice would be
greatly appreciated. Thanks

The less the user has to do the better.

I can supply a copy of the Spread sheet if it would help.


--
Azrael

Azrael Wrote:
I need to be able to record(keep) data from a number of cells on one
page to another page so that a user can go back and input other data at
a later date so as to be able to chart/ track the difference.

i.e. track by date
Cell D44 (Hrs Allocated dept 100)
Cell D45 (Hrs Allocated dept 101)
Cell D46 (Hrs Allocated dept 113)
Cell D47 (Hrs Allocated Dept 109)

The user will supply the date:

On a seperate work sheet a user will supply the hours used in each dept
and a formula will subtract Used from allocated to get the number that I
need.

Formulas already in place will fill in the numbers for the above cells.
I'm thinking some kind of form function. Any help or advice would be
greatly appreciated. Thanks

The less the user has to do the better.

I can supply a copy of the Spread sheet if it would help.
Use Access! I'm not trying to be a smarty but, Access is a better tool
to use to keep data and it can still manipulate numbers the way that
Excel does. Too many people seem to want Excel to be a database but it
isn't.


--
jahoobob