View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James[_14_] James[_14_] is offline
external usenet poster
 
Posts: 25
Default modify formulas with dropdown

I use a macro to add sheets as needed and name them
according to the date,(Nov 17 03) and add the name to a
list.

I would like to have a dropdown to pick a sheet and
several formulas to tell the contents of that particular
page. (Actually several dropdowns so I can compare
several dates together)

How can I reference the correct sheet in my formulas,
with out using a macro?