Hello,
I'm trying to obtain VMA code to auto filter based on the value of a static cell.
My data is in cells A5:AH169000 with the headings on from A4:AH4.
The cell I want to auto filter on is D2.
The column I want filtered is AF.
Sheet name = Contracts
eg. If I type "12345" into cell D2, column AF will automatically filter by "12345".
The data itself is obtained from a Access Query, which I update using a macro button (Not sure if that affect anything).
If anyone could help me out, I'd be very grateful!
Bookmarks