Searching for multiple values in excel

February 9, 2011 at 18:39:37
Specs: Windows XP, 768mb
I have 3 lists, a master locker register, an employee list, and a resignee list.

I have to update the master locker register referring to the resignee list. below is the example of a value in the master locker register

floor | locker number |staff name| *employee ID*| process | line mgr| extension|
2 s345 adam 43614985 SS mada 2589

the resignation list is basically the same thing but the thing is someone else is editing it and i find it difficult that the person editing it puts in values all across (according to date) instead of just adding on to the list (which is much easier as i will be able to track the changes)

i am also doing this very annoying manual cut and paste method. the value that i need to compare between the 2 is the employee ID. please help


See More: Searching for multiple values in excel

Report •

#1
February 9, 2011 at 20:17:18
First, please repost your data after reading the How To referenced in my signature line.

Second, keep in mind that we can't see your spreadsheet from where we're sitting, so we have no idea what this means:

"the person editing it puts in values all across (according to date) instead of just adding on to the list"

Please explain, or better yet, post an example - after reading the How To.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question