W.E.B
asked on
Excel Macro - Lookup-Highlight
Hello,
Can you please help with a Sub ,
I need to lookup the Tracking in Column "C" inside cells in column "B".
if tracking found, highlight both tracking numbers. (Red Bold Font), and in column "D" enter Line Number Found in.
Your help is appreciate.
Sample attached.
-Sample.xlsx
Can you please help with a Sub ,
I need to lookup the Tracking in Column "C" inside cells in column "B".
if tracking found, highlight both tracking numbers. (Red Bold Font), and in column "D" enter Line Number Found in.
Your help is appreciate.
Sample attached.
-Sample.xlsx
ASKER
Hello Rgonzo1971,
Thank you very much.
it worked.
the only thing (which is my fault, I didn't add to the sample file), if the tracking number was found on multiple lines.
is it possible to show both lines it's found on.
Also,
when I run the sub more than once, the line numbers keep showing for empty cells.
Sample attached.
Thanks again.
-Sample.xlsx
Thank you very much.
it worked.
the only thing (which is my fault, I didn't add to the sample file), if the tracking number was found on multiple lines.
is it possible to show both lines it's found on.
Also,
when I run the sub more than once, the line numbers keep showing for empty cells.
Sample attached.
Thanks again.
-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome,
Thank you very much.
Thank you very much.
pls try
Open in new window
Regards