Hello everyone,
I'm working on a way to filter a running table I have using criteria that is dynamic. I had originally hoped to use VBA for this, but to no avail.
I attached an example of what I am hoping to accomplish; on Sheet1, whatever combination of cells G2 and H2 are, I would like the filtered results from Sheet2 to be compiled within columns A:D on Sheet1. I know I could just use AutoFilter on the actual table within Sheet2, but the end goal is to have this as a front-end worksheet for the user, so minimum interaction with the database is preferred.
Hope I was clear, and thanks to everyone in advance for any help.
Bookmarks