How to make a range of cells react to changes in one cell

E

eleonore

Hello,

There has got to be a name and a formula to do what I'm trying to do, I just
know it! Hopefully one of you smart, helpful folks will be able to assist me.

I am creating a budget proposal with various ranges of data. Instead of
having to create multiple lines of how much things would cost for 10
speakers, 12 speakers, 15 speakers, etc, I would like to have a drop-down
list in a cell titled "number of speakers," and then have my range of expense
cells, "travel," "food," lodging," etc., change to reflect the number of
speakers (or whatever) being chosen.

Is this something that is even possible to create?

Thank you for any help at all!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Conditional Formatting - Can I Make One Cell React To A Range? 0
Pasting a range to a single cell 0
Define a Range based on Cell Values 2
Varying cell ranges in formulas according to number of cells with certain value 1
*Issue* Concatenate dates in a large range of cells in a row. 5
Return a value if a range of cells contain text 2
How do I have a cell value define a dynamic named range? 15

Top