View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Britt Britt is offline
external usenet poster
 
Posts: 7
Default how do you use formulas in a drop down box

I am trying to make a drop down box with formulas -- I have a spread sheet
with 15 plus tabs and the colums would be the same always but the numbers
changes -- i know when you paste special it auto calulates the cells -- So
can youdo this with the drop down box??? Example : @sum(a1*h7) or @sum(b1*f7)
thank you for all your help ...