sllaksvb
10-17-2017, 09:21 AM
Hi all,
I'm working on a project that requires me to return results from a master list based on the filters specified. However, I'm not sure how to go about tackling this as my knowledge is not in depth enough.
What I'm looking to do is, in Workbook REQUIREMENTS, specify all TV brands and locations that I approved (can be more than 1, as shown in example)
Then, click generate, which would prompt me to open a file (which I will use to open MASTER).
After clicking, it will compare the TV brands with the TV brands and locations in the masterlist, and return the ones that match both criteria to workbook REQUIREMENTS (Should only return results that match both criteria, as shown in example).
This macro is meant to be dynamic (Should be able to add additional criterias in both workbooks) and still function.
(i.e. If i add TV Size as a category, with 40, 60, 65, as my criteria on both workbooks, should be able to use it as a filter criteria.)
Any suggestions or guidance is greatly appreciated! Thank you.
2067820679
I'm working on a project that requires me to return results from a master list based on the filters specified. However, I'm not sure how to go about tackling this as my knowledge is not in depth enough.
What I'm looking to do is, in Workbook REQUIREMENTS, specify all TV brands and locations that I approved (can be more than 1, as shown in example)
Then, click generate, which would prompt me to open a file (which I will use to open MASTER).
After clicking, it will compare the TV brands with the TV brands and locations in the masterlist, and return the ones that match both criteria to workbook REQUIREMENTS (Should only return results that match both criteria, as shown in example).
This macro is meant to be dynamic (Should be able to add additional criterias in both workbooks) and still function.
(i.e. If i add TV Size as a category, with 40, 60, 65, as my criteria on both workbooks, should be able to use it as a filter criteria.)
Any suggestions or guidance is greatly appreciated! Thank you.
2067820679