Filter the data based on uncertain criterias and past them in dynamically created shapes with VB

thespardian

Board Regular
Joined
Aug 31, 2012
Messages
71
Office Version
  1. 2016
  2. 2013
Platform
  1. 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
PIC 1.png


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
PC 2.png


Any help on the matter will be highly appreciated. Here is the link of file
Book4.xlsm
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,123,453
Messages
5,601,755
Members
414,471
Latest member
cchunyadi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top