programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
Hi gang,
I'm trying to find the best way to approach this issue and I have no idea where to start and I've bounced around from idea to idea and cannot put the pieces together.
Here's what I want to do.
I've got a file that when opened, automatically identifies the name of the user that is logged in and places that name in a hidden worksheet called "Users" in cell F4.
On a separate worksheet entitled "Partners", I've got a table of data that updates every time the file is opened. One column of data (Column A) contains the names of the different users that could potentially log in and the corresponding column (Column B) contains partners that will work alongside the user. What I want is for the system to recognize whom is logged in, locate that name in Column A and return ALL of the potential partners that correspond that name in Column B in to a list on a worksheet entitled "Dashboard". As an example, the data would look something like this.
<table>
<tr><td>Users:</td><td>Partners:</td></tr>
<tr><td>Tom Jones</td><td>A & L LLC</td></tr>
<tr><td>Tom Jones</td><td>RapidRock Mining</td></tr>
<tr><td>Cindy Marek</td><td>Gypsum Craftwerks</td></tr>
<tr><td>Tom Jones</td><td>Milestone Group</td></tr>
<tr><td>Alan Jameson</td><td>Harpoon Services</td></tr>
</table>
So, the system will automatically recognize the name of the User, pull data from the table that corresponds and display it in a list on another worksheet.
I've racked my brain on the best approach be it VBA, Data Validated List (not sure how it would work) or some mixture of the two.
Your assistance is much appreciated.
I'm trying to find the best way to approach this issue and I have no idea where to start and I've bounced around from idea to idea and cannot put the pieces together.
Here's what I want to do.
I've got a file that when opened, automatically identifies the name of the user that is logged in and places that name in a hidden worksheet called "Users" in cell F4.
On a separate worksheet entitled "Partners", I've got a table of data that updates every time the file is opened. One column of data (Column A) contains the names of the different users that could potentially log in and the corresponding column (Column B) contains partners that will work alongside the user. What I want is for the system to recognize whom is logged in, locate that name in Column A and return ALL of the potential partners that correspond that name in Column B in to a list on a worksheet entitled "Dashboard". As an example, the data would look something like this.
<table>
<tr><td>Users:</td><td>Partners:</td></tr>
<tr><td>Tom Jones</td><td>A & L LLC</td></tr>
<tr><td>Tom Jones</td><td>RapidRock Mining</td></tr>
<tr><td>Cindy Marek</td><td>Gypsum Craftwerks</td></tr>
<tr><td>Tom Jones</td><td>Milestone Group</td></tr>
<tr><td>Alan Jameson</td><td>Harpoon Services</td></tr>
</table>
So, the system will automatically recognize the name of the User, pull data from the table that corresponds and display it in a list on another worksheet.
I've racked my brain on the best approach be it VBA, Data Validated List (not sure how it would work) or some mixture of the two.
Your assistance is much appreciated.