P
pfdubz
I have done this before in Dbase (Boy, am I old!) and don't want to use
Access becauseExcel is more user friendly and I can produce charts and pivot
tables from the database that suit my purpose.
I have a database that keeps track of workload projections with the
following columns:
Name Project Week Ending Hours
We try to project workload for personel as far out as a yesr in advance.
Needless to say, it is not uncommon for someone's workload assignment to be
revised as time goes by.
On a separate worksheet, I want to call up the person's name, the project,
and the week ending to see if he has any hours already posted. If the person
does, and it is wrong, I want to revise it and update the database without
leaving the separate worksheet. If he does not, I want to add a new record
to the database. If everything is ok, I just wnat to contionue without
modifying the database.
If i need a macro to do this all, that is fine with me. I just need some
HELP on how to set it up.
Access becauseExcel is more user friendly and I can produce charts and pivot
tables from the database that suit my purpose.
I have a database that keeps track of workload projections with the
following columns:
Name Project Week Ending Hours
We try to project workload for personel as far out as a yesr in advance.
Needless to say, it is not uncommon for someone's workload assignment to be
revised as time goes by.
On a separate worksheet, I want to call up the person's name, the project,
and the week ending to see if he has any hours already posted. If the person
does, and it is wrong, I want to revise it and update the database without
leaving the separate worksheet. If he does not, I want to add a new record
to the database. If everything is ok, I just wnat to contionue without
modifying the database.
If i need a macro to do this all, that is fine with me. I just need some
HELP on how to set it up.