I'm not sure what this is called or Google would be more help. haha.
I'm working on an hardware budget excel sheet for my group.
Right now, I have a hardware and software section.
If I increase the number of say Mac laptops, I would like to increase the number of certain software packages as well.
Any help?
no idea what you are talking about ! got an example?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
If you have a cell that holds the quantity of Mac Laptops (M1) and another cell that is supposed to hold an equal number of software packages (S1), then put this in S1:
=M1
Now any changes in M1 will change the value of S1, too.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks