View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Derrick Derrick is offline
external usenet poster
 
Posts: 133
Default option panes/ drop down lists

is it possible for me to make a drop down list /option pane on one sheet,
while getting the cells for the list from another sheet?
my goal is to use that option pane as a tool to make match functions work
with exact matches
any help?