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.

On Mar 23, 3:03*am, Angela 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.

Any updated guys?

I sent her a workbook solving this.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Angela" wrote in message
...
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.

Thanks Don.

I got an email from her asking for help.

I will ignore it.


Gord

On Sun, 23 Mar 2008 10:40:33 -0500, "Don Guillett"
wrote:

I sent her a workbook solving this.