thespardian
Board Regular
- Joined
- Aug 31, 2012
- Messages
- 119
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi there! I am looking for a big help from you guys. I want a macro with Microsoft 2013 which can perform following functions.
1)
I want to Filter the items from the table in column A: E on sheet2 (Price List) based on the five or four or three or two or one criterias mentioned in K2:K6 ( if one or two or three or four out of five criteria is missing, the filter should ignore the missing criterias and work with the available criteria/criterias). copy that data and past it in the column N: R is the sheet 2
2
Then i want to creat dynamic text boxes (for item ID and Item Name) from that above filter data on sheet1 starting from row 15 to downward. But it shoud not exceed the column J.
3
when i click any of the above text box, the Item ID should be appear in cell E10 of Sheet1
1)
I want to Filter the items from the table in column A: E on sheet2 (Price List) based on the five or four or three or two or one criterias mentioned in K2:K6 ( if one or two or three or four out of five criteria is missing, the filter should ignore the missing criterias and work with the available criteria/criterias). copy that data and past it in the column N: R is the sheet 2
2
Then i want to creat dynamic text boxes (for item ID and Item Name) from that above filter data on sheet1 starting from row 15 to downward. But it shoud not exceed the column J.
3
when i click any of the above text box, the Item ID should be appear in cell E10 of Sheet1
Book4.xlsmAny help on the matter will be highly appreciated. Here is the link of file