Anyone know how to do this in Numbers?

Discussion in 'Mac Apps and Mac App Store' started by jakesaunders27, Apr 2, 2015.

  1. jakesaunders27 macrumors 6502a

    jakesaunders27

    Joined:
    Jan 23, 2012
    Location:
    United Kingdom
    #1
    Hi,

    Looking at creating a sales sheet for my business.

    I want to have the months across the top and then be able to choose a product from a dropdown and it puts in its price but then also displays how much profit I make and then the remaining price that needs to be paid to the manufacturer which then totals up at the end of the month so I know how much profit I make each month and how much I pay the supplier that month if that makes sense!?

    something like the screenshot, hard to explain hopefully someone gets what i want. Feel free to ask me more as I could do with sorting this out.

    Cheers
    Jake
     

    Attached Files:

  2. dyt1983, Apr 2, 2015
    Last edited: Jun 2, 2015

    dyt1983 macrumors 65816

    Joined:
    May 6, 2014
    Location:
    USA USA USA
    #2
    edit: To remove personally identifying information not relevant to the thread.
     
  3. sracer macrumors 603

    sracer

    Joined:
    Apr 9, 2010
    Location:
    Land of Bongos and Beatniks
    #3
    Take a look at this video. Keep in mind it might not work with the latest version of Numbers (if it has been as dumbed down as Pages has been).
     
  4. jakesaunders27 thread starter macrumors 6502a

    jakesaunders27

    Joined:
    Jan 23, 2012
    Location:
    United Kingdom
    #4
    Yes thats correct, I'll take a look at Quickbooks.

    ----------

    I'll take a look, thanks.
     
  5. dyt1983, Apr 2, 2015
    Last edited: Jun 2, 2015

    dyt1983 macrumors 65816

    Joined:
    May 6, 2014
    Location:
    USA USA USA
    #5
    edit: To remove personally identifying information not relevant to the thread.
     
  6. jakesaunders27 thread starter macrumors 6502a

    jakesaunders27

    Joined:
    Jan 23, 2012
    Location:
    United Kingdom
    #6
    Yep just worked out how to create a drop down just getting the formulas right now

    ----------

    Quickbooks is a bit expensive for what I want to do, just wanted to do this in Numbers
     
  7. dyt1983, Apr 2, 2015
    Last edited: Jun 2, 2015

    dyt1983 macrumors 65816

    Joined:
    May 6, 2014
    Location:
    USA USA USA
    #7
    edit: To remove personally identifying information not relevant to the thread.
     
  8. jakesaunders27 thread starter macrumors 6502a

    jakesaunders27

    Joined:
    Jan 23, 2012
    Location:
    United Kingdom
    #8
    Thanks so much, I'll try it out tomorrow, it's late here in the UK!
     
  9. dyt1983, Apr 2, 2015
    Last edited: Jun 2, 2015

    dyt1983 macrumors 65816

    Joined:
    May 6, 2014
    Location:
    USA USA USA
    #9
    edit: To remove personally identifying information not relevant to the thread.
     
  10. jakesaunders27 thread starter macrumors 6502a

    jakesaunders27

    Joined:
    Jan 23, 2012
    Location:
    United Kingdom
    #10
    Not too sure how I want to set it out, thats not really what I'm after. As I want it to work out the profit for me and how much I have to pay that was the point in the sheet or have I misunderstood you?

    Maybe what I'm trying to do isn't possible?!

    Even if I didn't have drop downs I would like to be able to say type PRODUCT0001 into the field and it could maybe pull the data from another sheet or something so it knows how much it costs on the site how much I make and how much I need to pay the supplier for that item?

    Cheers
     
  11. sracer macrumors 603

    sracer

    Joined:
    Apr 9, 2010
    Location:
    Land of Bongos and Beatniks
    #11
    Yes that's do-able. I suggest looking into the vlookup function... that will allow you to have a separate "reference" table of products, costs, and prices, and pull the data you want from it.
     
  12. dyt1983, Apr 3, 2015
    Last edited: Jun 2, 2015

    dyt1983 macrumors 65816

    Joined:
    May 6, 2014
    Location:
    USA USA USA
    #12
    edit: To remove personally identifying information not relevant to the thread.
     

Share This Page