Sunjinsak
Board Regular
- Joined
- Jul 13, 2011
- Messages
- 143
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>
I’ll try to explain this as best I can…
<o></o>
I need to create a database of individuals and their associated team names, location, positions, contact details etc using Excel 2003. Unfortunately we do not have access to any database programs in work so Excel is the only option.
<o></o>
What I need is fairly complex and I’m not even sure Excel is up to the job but here goes anyway…
<o></o>
Basically, an individual can be a member of one or more of a specific number of teams. Also, there are two possible geographic locations for these teams, then further location-specific info within the geographic locations (e.g. floor, wing, internal telephone extension and e-mail address).
<o></o>
I need to create one “control sheet” with everybody’s details on – sorted in alphabetical order – but then have these people appear on separate sheets within the same workbook based on their location and the different teams they’re a member of.
<o></o>
The geographic locations are LH and TR, and they could be a member of any of the following teams; IR, HS, ULR, BEC or PCW.
<o></o>
I’m hoping to have a page each for the two locations (LH and TR) and on each page have buttons linking to lists for the individual teams in that site (IR, HS, ULR, BEC and PCW).
<o></o>
Ideally I’d like to only have to update people’s details on the control sheet and have those changes reflected across the other pages (as there are 200+ people on the list).
<o></o>
For example:
Person A, based in LH, member of IR, HS and PCW
Person B, based in LH, member of IR, HS, ULR, BEC, PCW
Person C, based in TR, member of HS
<o></o>
Person A would show up on the IR, HS and PCW pages under the LH location
Person B would show up on the IR, HS, ULR, BEC and PCW pages under LH
Person C would only show up on the HS page under TR.
<o></o>
If Person C then becomes a member of BEC I can “set” BEC against their name in the control sheet and they will then show up on both the HS and BEC pages under TR automatically.
<o></o>
No one will show up on a list for a team of which they are not a member, or in a location they are not based.
<o></o>
Does that make sense? Is it possible to achieve in Excel? If so how do you suggest I go about it?
<o></o>
I can use VBA if necessary and – at least as far as I know – there are no restrictions in place in terms of Excel functionality.
<o></o>
The only restriction is that this whole “database” needs to be kept in one workbook.
<o></o>
Thanks.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o>I’ll try to explain this as best I can…
<o
></o>I need to create a database of individuals and their associated team names, location, positions, contact details etc using Excel 2003. Unfortunately we do not have access to any database programs in work so Excel is the only option.
<o
></o>What I need is fairly complex and I’m not even sure Excel is up to the job but here goes anyway…
<o
></o>Basically, an individual can be a member of one or more of a specific number of teams. Also, there are two possible geographic locations for these teams, then further location-specific info within the geographic locations (e.g. floor, wing, internal telephone extension and e-mail address).
<o
></o>I need to create one “control sheet” with everybody’s details on – sorted in alphabetical order – but then have these people appear on separate sheets within the same workbook based on their location and the different teams they’re a member of.
<o
></o>The geographic locations are LH and TR, and they could be a member of any of the following teams; IR, HS, ULR, BEC or PCW.
<o
></o>I’m hoping to have a page each for the two locations (LH and TR) and on each page have buttons linking to lists for the individual teams in that site (IR, HS, ULR, BEC and PCW).
<o
></o>Ideally I’d like to only have to update people’s details on the control sheet and have those changes reflected across the other pages (as there are 200+ people on the list).
<o
></o>For example:
Person A, based in LH, member of IR, HS and PCW
Person B, based in LH, member of IR, HS, ULR, BEC, PCW
Person C, based in TR, member of HS
<o
></o>Person A would show up on the IR, HS and PCW pages under the LH location
Person B would show up on the IR, HS, ULR, BEC and PCW pages under LH
Person C would only show up on the HS page under TR.
<o
></o>If Person C then becomes a member of BEC I can “set” BEC against their name in the control sheet and they will then show up on both the HS and BEC pages under TR automatically.
<o
></o>No one will show up on a list for a team of which they are not a member, or in a location they are not based.
<o
></o>Does that make sense? Is it possible to achieve in Excel? If so how do you suggest I go about it?
<o
></o>I can use VBA if necessary and – at least as far as I know – there are no restrictions in place in terms of Excel functionality.
<o
></o>The only restriction is that this whole “database” needs to be kept in one workbook.
<o
></o>Thanks.
