| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update worksheet - Based on user IDs list
Hi,
I have a worksheet with header in first cell A1 to K1. In columnJ sarting from J1, I have some USER-IDs. I have a defined list of users as SUserin worksheet Temp. Based on the SUser, I want to remove all other rows, leaving behind rows of SUsers only. Also if SUser list is updated (added/removed) with a new user, it should work accordingly. Thx. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Update worksheet - Based on user IDs list
You don't need code for this. Just hide the extra rows. The as the list
grows or shrinks, either insert or delete rows. "Sinner" wrote: Hi, I have a worksheet with header in first cell A1 to K1. In columnJ sarting from J1, I have some USER-IDs. I have a defined list of users as SUserin worksheet Temp. Based on the SUser, I want to remove all other rows, leaving behind rows of SUsers only. Also if SUser list is updated (added/removed) with a new user, it should work accordingly. Thx. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate List or Combo box based on User ID | Excel Programming | |||
| Update Formula's based on drop down list value | Excel Worksheet Functions | |||
| How to update worksheet colours based on worksheet name | Excel Discussion (Misc queries) | |||
| update cell in other worksheet based... | Excel Worksheet Functions | |||
| Creating a User Form to update a list | Excel Programming | |||
Linear Mode
