Hi All,
I vlookup data from my master sheet to 2 different sheets in the same workbook
and sometimes I get blank cells so I filtered them out and I used VBA to make the filter run automatically when I select any project from my drop-down list to lookup his values
but I had to write it on every sheet to make it run as you can see below and its mede my workbook slow:
i need you hlep to fix this issue (when i write it only in the 2 sheets that i need it to run in, it dosent work)
I vlookup data from my master sheet to 2 different sheets in the same workbook
and sometimes I get blank cells so I filtered them out and I used VBA to make the filter run automatically when I select any project from my drop-down list to lookup his values
but I had to write it on every sheet to make it run as you can see below and its mede my workbook slow:
i need you hlep to fix this issue (when i write it only in the 2 sheets that i need it to run in, it dosent work)