Hi all,
Question1-
The idea is:
When selecting a cell in table sheet1 the value is shown in cell B6. When the Search button is pressed the value in cell B6 is filtered in table sheet2. So the value being looked up can differ but is always looked up in the same column. Also the macro first unfilters the table first.
When I program the macro in the same sheet it works, but i think my code is having trouble at the end reffering to the cell on the right sheet. Can anybody help me out?
This is the code:
Question2-
The length of the tables on sheet1 and sheet2 differs. Do I need to change the code to some kind of 'end of table' code? What should i do then?
Bookmarks