Database updates
 

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.
--
Paul

Database updates
 

Hi,

Instead of calling the person's record on a separate sheet try using the
built in form function in Excel. To do this (Excel 2003):

1. Select any cell in your data table.
2. Select Data from the menu.
3. Select Form.

This will display a form with the first recod in your data displaying. From
there, you can call up the user's record through the criteria option and then
make changes if necessary.

If this helps, please press Yes.

JCS

"pfdubz" wrote:

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.
--
Paul

Database updates
 

I rated it "no" and maybe should have rated it "sorta" but did not have that
option. It gives me the opportunity to find a record in the database and
revise it. Yes. and I have set up a split screen so that I can input the
data on one screen and use "Advance" on the Sort & Filter option on the Data
ribbon (Excel 2007). The split screen allows me to access the criteria range
a little easier. Anyway, I can access existing data, but what if there is no
data to match the criteria? Right now, the command drops to the bottom of my
range which I have set much larger thatn the database so tht I can captur new
entries. The advanced drops me to the bottom and I have empty rows in the
database. Plas that, it wont drop down another row as new entries are
required.
--
Paul


"JCS" wrote:

Hi,

Instead of calling the person's record on a separate sheet try using the
built in form function in Excel. To do this (Excel 2003):

1. Select any cell in your data table.
2. Select Data from the menu.
3. Select Form.

This will display a form with the first recod in your data displaying. From
there, you can call up the user's record through the criteria option and then
make changes if necessary.

If this helps, please press Yes.

JCS

"pfdubz" wrote:

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.
--
Paul