Moique,

Sure. Use the worksheet selection change event to feed the filter parameters to the autofilter for
that table, along the lines of this, placed into the worksheet's codemodule:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
Range("B2:C8").AutoFilter Field:=1, Criteria1:=Target.Value
End Sub

HTH,
Bernie
MS Excel MVP


"Monique" wrote in message
...
For display purposes, I only want to see that row on that page though. Is
that possible?

"Bernie Deitrick" wrote:

You could use the worksheet's selection change event to change a cell used by a VLOOKUP formula
to
extract the data related to Parameters.

--
HTH,
Bernie
MS Excel MVP


"Monique" wrote in message
...
i have a workbook that has a Parameters page. Right now, all the information
shows no matter the selection on the Control page. I want to make it so
depending on the variable selected on the Control page, the Parameters just
shows items related to the selection.

Control -- user picks A

Parameters -- only display things related to A (which is a row of data)

If anyone could offer any help.

Thanks