I have a userform that will be used by multiple users. I'd like to set it up so that when the user chooses their team # it pulls that number team tracker and accesses the team roster. Here is the path TXfs02/Team Trackers. The roster is located on 'tenure' tab column D starting at D4.
Also once it access the roster depending on which name on the roster is chosen it then accesses that file name and places the appropriate data.
Also once it access the roster depending on which name on the roster is chosen it then accesses that file name and places the appropriate data.
Team 2 Tracker(1).xls | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
4 | Apicelli,Joanna | 40 | 9/13/2004 | |||
5 | Brisco,Lestrease | 40 | 8/30/2004 | |||
6 | Garcia,Elizabeth | 40 | 5/3/2004 | |||
7 | Gonzales,Sam | 30 | 10/31/2000 | |||
8 | Graham,Amber | 40 | 9/13/2004 | |||
9 | Head,Antoinette | 40 | 2/23/2004 | |||
10 | Johnson,Angelina | 40 | 9/13/2004 | |||
11 | Kanz,Kelly | 40 | 8/30/2004 | |||
12 | Kinsch,Adrienne | 40 | 8/2/2004 | |||
13 | Kohler,Michael | 40 | 4/19/2004 | |||
14 | Lawless,Teresa | 40 | 4/15/2003 | |||
15 | Lighty,Robert | 40 | 7/21/2003 | |||
16 | Mariscal,Emmanuel | 40 | 5/10/2004 | |||
17 | Martinez,MichaelJ. | 30 | 8/16/2004 | |||
18 | Mesquiti,Sophia | 40 | 5/27/2003 | |||
19 | Muniz,David | 30 | 5/5/2003 | |||
20 | Narvaez,Jessica | 40 | 6/23/2003 | |||
21 | Okuyemi,Seyi | 40 | 9/13/2004 | |||
22 | Pena,Vanessa | 40 | 8/30/2004 | |||
23 | Pena,Veronica | 40 | 8/30/2004 | |||
24 | Perez,Chrystal | 40 | 9/13/2004 | |||
25 | Perez,Emanuel | 40 | 6/23/2003 | |||
26 | Perez,Michael | 40 | 3/22/2004 | |||
27 | Ramirez,Valerie | 40 | 9/27/2004 | |||
28 | Resendez,Rudy | 30 | 2/23/2004 | |||
29 | Sarabia,Jane | 40 | 8/30/2004 | |||
30 | Senties,Raquel | 40 | 9/27/2004 | |||
31 | Thorton,Sarah | 40 | 5/3/2004 | |||
Tenure |