Automation? Database?

  • Thread starter Thread starter Louie Warren
  • Start date Start date
L

Louie Warren

I have a huge spreadsheet. It contains various groups of
people. Certain people are in each worksheet/group. I
have a master list of these people. I would like to be
able to have a static position on each worksheet that
would be a lookup in the master list. Once a person is
selected, all the info is populated in the target
worksheet. I know this would be better done in a
database, but I don't have the time or funding to create
one and migrate all this data. If it's quick and dirty,
that's fine. If I can't get there from here, that's fine
too. Thanx!
 
I have a huge spreadsheet. It contains various groups of
people.
Click to expand...

Over 20 worksheets. Each worksheet has a role field, a
name field (1st & last), one phone number, another phone
number, a group name, an e-mail address, an ID, and a
password.
Certain people are in each worksheet/group. I
have a master list of these people. I would like to be
able to have a static position on each worksheet that
would be a lookup in the master list. Once a person is
selected, all the info is populated in the target
worksheet.
Click to expand...

For the explanation, each row in the sheet is a record of
a person in the project or group. The admin/manager types
are static in quite a few worksheets; therefore, I have
another worksheet with each type. I want to be able to go
to a new worksheet, and have a drop down showing everyone
in the type sheet. I select one, and the remainder of the
fields are populated from that sheet. I seem to remember
doing something similar to this with a pivot table, but
don't remember.
I know this would be better done in a
database, but I don't have the time or funding to create
one and migrate all this data. If it's quick and dirty,
that's fine. If I can't get there from here, that's fine
too. Thanx!
.
Click to expand...

It screams out for database, but I don't have the budget
to do that. Thanx for the assistance
 
I have a huge spreadsheet. It contains various groups of
people.
Click to expand...

Over 20 worksheets. Each worksheet has a role field, a
name field (1st & last), one phone number, another phone
number, a group name, an e-mail address, an ID, and a
password.
Certain people are in each worksheet/group. I
have a master list of these people. I would like to be
able to have a static position on each worksheet that
would be a lookup in the master list. Once a person is
selected, all the info is populated in the target
worksheet.
Click to expand...

For the explanation, each row in the sheet is a record of
a person in the project or group. The admin/manager types
are static in quite a few worksheets; therefore, I have
another worksheet with each type. I want to be able to go
to a new worksheet, and have a drop down showing everyone
in the type sheet. I select one, and the remainder of the
fields are populated from that sheet. I seem to remember
doing something similar to this with a pivot table, but
don't remember.
I know this would be better done in a
database, but I don't have the time or funding to create
one and migrate all this data. If it's quick and dirty,
that's fine. If I can't get there from here, that's fine
too. Thanx!
.
Click to expand...

It screams out for database, but I don't have the budget
to do that. Thanx for the assistance.
 
Back
Top