Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Applying users to site/names
I have 20 or so excel workbooks that are created at an external source and
downloaded to our server. Each workbook contains a site and names that belong to that site as well as all sorts of other data, but the site and name fields are not in the same column location in every file. Here is the issue: I have multiple users who are trying to display just the list of the sites/names each user is responsible for. One way of doing this is to have a separate spreadsheet that contains columns with the site number and the initials of the user, and somehow (this is where your help is needed) we can create a link between the two files. Once the link has been set, the users can autofilter on their initials and find the sites/names they are responsible for. If you have a better idea please share! I should probably tell you I am not much for programming, but I am willing to try. Thank you, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for Excel site similar to "The Word MVP Site" | New Users to Excel | |||
sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
How to take a list of names & addresses from web site into Excel | Excel Discussion (Misc queries) | |||
Applying range names to existing formulas in separate worksheets | Excel Discussion (Misc queries) | |||
Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions |