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