Hello everyone, I am trying to build a table that gives profitability of about 10 different items. For ecample there are 10 different type of bikes, at different prices and margins. The table lists all the detail for the calculations by multipling price * margin at various levels of production-output weekly.
See example below, it is a simpler version of exactly what I am trying to do. Thanks ahead for any and all who help and respon!
Luke
profit model.PNG
model-macro.xlsx
Have you tried a Pivot table? (they're wonderful)
I've built one but I am building this for someone that is specifically asking for a macro button. How would u suggest i go about the pivot table ad explaining that it would accomplish the same thing?
Say that the benefits and flexibility of a Pivot Table is Way better than creating a specif macro for this, everytime your 'guy' wants to change the way the sheets looks like, you would need to change the macro, with pivot table you just drag some filters and values and are done.Originally Posted by wls485
Last edited by stephenloky; 07-10-2014 at 12:36 PM.
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
I see, I wish I could but I'm afraid I have to move forward with the macro. I just checked with them and thats what they want. Long satnding manufacturing company not much change in their business except price and volume. Thanks so much for the advise though, if you have any macro tips I'd be thankful too!
You need to create a customized macro...If you learn VBA (I don't know if you already know it) ... It's 'easy' by the way. Good Luck!!!
Learning materials - > http://www.excelforum.com/excel-prog...materials.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks