LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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 ...
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you add formulas into drop boxes?? AmieS Excel Worksheet Functions 1 August 17th 07 11:22 AM
formulas and drop down lists drwrbrts Excel Worksheet Functions 1 June 6th 06 12:00 AM
drop down formulas Tim Excel Worksheet Functions 1 May 22nd 06 06:17 AM
using formulas in a drop down box Matt Excel Worksheet Functions 0 July 28th 05 02:36 PM
formulas from a drop down box Lisa H via OfficeKB.com Excel Discussion (Misc queries) 6 May 28th 05 01:18 AM


All times are GMT +1. The time now is 01:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"