Hi,
Hope someone can help with the following:
I have a spreadsheet with a 10,000 names and another with 200 names.
I wish to find out whether any of these 200 names appear in the spreadsheet with the 10,000 names and have the lines with any associated data to these names highlighted/selected.
I also would need to repeat that proces with new short lists every other day so is there anyways of automating this?
How does one go about it efficiently?
Many thanks to anyone who reads this and are able to help.
ZE
Hope someone can help with the following:
I have a spreadsheet with a 10,000 names and another with 200 names.
I wish to find out whether any of these 200 names appear in the spreadsheet with the 10,000 names and have the lines with any associated data to these names highlighted/selected.
I also would need to repeat that proces with new short lists every other day so is there anyways of automating this?
How does one go about it efficiently?
Many thanks to anyone who reads this and are able to help.
ZE