Filter by User ID

  • Thread starter Thread starter Nelson Mather
  • Start date Start date
N

Nelson Mather

I have a task spreadsheet that needs to be updated by many users. The
spreadsheet is in shared mode.

How do I get the spreadsheet to automatically filter by the user Id on
opening the file?

I had thought of using a lookup table but cannot figure out how to capture
the information in the "User Name" field in the Options | General tab.
 
This tiny UDF will give you the name of the current user:

Public Function UserName2() As String
UserName2 = Environ("UserName")
End Function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Filtering 2
Filter by Rows?? 2
VLookup Method for Comma Delimited Field 1
Excel 2007 compatibility issue - speed between cells 2
PIvot Tables 2003 and VLookup 5
Advanced Filter - how do you get it to go away 7
Filter Condition 2
Manipulating Excel Online and/or for Many Shared Users 3

Back
Top