Adding a specific lookup to an existing macro

[JO505]

I have a sheet that displays customer data from a data table using Index, Match functions. On that same sheet (Customer Data) I have a "Button" created from the drawing tools, with it I am able to open the sheet.

I want to add the capability of opening the data table but also highlighting the specific row as defined by value in cell N12 of the same sheet that the button is on.

I.E. from the "Customer Data" sheet I select a customer from a list and their address, phone number etc. is displayed. Cell N12 shows the row on the master data sheet to find the data. I wish to highlight that row when the sheet is opened.

The macro I recorded is as follows.

Please Login or Register  to view this content.

Thanks

Jim O

[JBeaucaire]

So perhaps:

Please Login or Register  to view this content.