excel macros
-
hi there , say i have a few tables ... is it possible to search for the data i want by using a form .. ?? i have done so by using filters .. but is there other ways of doing it ?? 1 more thing .. i can only filter by the data in the columns , but what if i want to display only the few columns i select in the form ... how do i go about it ...
pnl.text , pf.text and product.text are combo boxes .. the rest of the combo boxes contain columns as the data not rows ... If pnl.Text = "ON" Then Range("B6:CJ178").Select Selection.AutoFilter Field:=1, Criteria1:=pf.Text Selection.AutoFilter Field:=2, Criteria1:=product.Text ElseIf pnl.Text = "OFF" Then Range("B180:CJ291").Select Selection.AutoFilter Field:=1, Criteria1:=pf.Text Selection.AutoFilter Field:=2, Criteria1:=product.Text ElseIf pnl.Text = "ON & OFF" Then Range("B293:CJ504").Select Selection.AutoFilter Field:=1, Criteria1:=pf.Text Selection.AutoFilter Field:=2, Criteria1:=product.Text End If