- Joined
- Jan 12, 2004
- Messages
- 21,888
Looking for some help here.
I have two different excel sheets. Sheet A lists an identification number, and Sheet B lists the identification number and an address field. Both have lots of other info as well, but these are the fields I'm interested in.
All of the identification numbers are on both Sheet A and B, but I need to filter off the numbers not listed on A, and keep the address field.
Is there a way to merge the sheets to filter off the extra information not needed on B?
Thanks
I have two different excel sheets. Sheet A lists an identification number, and Sheet B lists the identification number and an address field. Both have lots of other info as well, but these are the fields I'm interested in.
All of the identification numbers are on both Sheet A and B, but I need to filter off the numbers not listed on A, and keep the address field.
Is there a way to merge the sheets to filter off the extra information not needed on B?
Thanks