row select
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
|