View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nelson Mather Nelson Mather is offline
external usenet poster
 
Posts: 3
Default Filter by User ID

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.