Hi Guys,
Can somebody help me please. I work on big excel files with many product lines. Very frequently I need to filter product lines by product code. The way I do it now, is right click on the product code, the select filter and then filter by selected cell’s vale
What I need is a VBA that filters to me the cell where the mouse is, i.e. filter the relative reference (wherever the mouse is).
Thanks and appreciate our help.
Nasser
Dear All,
Appreciate if someone can help me with this one as i need it urgently.
regards
nasser
Dear All,
Appreciate if someone can help me with this one as i need it urgently.
regards
nasser
Dear Excel Gurus,
appreciate if someone can help me wiht this autofilter VBA, i desperately need it.
appreciate it.
Nasser
Copy the below code and do right click on sheet tab and select view code and paste it.
Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.
Do double click on any cell of that sheet which will trigger the autofilter
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks