Dynamic highlighting of rows

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a list of 200 names in sheet 1 and in sheet 2 i have more than 5000 plus names, with all the details like adress, phone number ,etc.

Now i want to write a macro, which when run looks at the names in sheet 1 goes to sheet 2 and higlights that row where that particular name exists. since I use it every week with many names adding and leaving i want it to be dynamic.

eg. :-
1 . sheet 1 has the name Raj.
2. I go to sheet 2 look for name Raj and make the entire row with data bold. similarly i have 200 Plus names.

can any one help me. I recorded the macro for this but its not dynamic.

thanks in advance

Raj

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too