View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Benjamin Benjamin is offline
external usenet poster
 
Posts: 102
Default Dependent List "Index" Problem

I'm using the template from:
http://www.contextures.com/xlDataVal15.html

I'm having a problem getting the pulldown menus to move to say start at
Cell G8 and the dependent at H8 as I have my Data Entry sheet formatted
differently.
As I don't want the drop downs on A2 and B2. I'm entering the "names" on G8
and H8 but no luck....

Can someone help me understand how to tweak the formulas to allow for this?
--