+ Reply to Thread
Results 1 to 2 of 2

Complete newbie that doesnt know what category this problem should be in, very sorry

  1. #1
    Registered User
    Join Date
    02-09-2021
    Location
    Selangor,Malaysia
    MS-Off Ver
    18.2008.12711.0
    Posts
    1

    Complete newbie that doesnt know what category this problem should be in, very sorry

    Hey people, so I have 3 excel sheets, one has the product details, second has the order details, and the last the total profits details.
    In the product details sheet, there's the pricing for each product with different IDs called SKU , and so I would like to insert the
    pricing of each product into the order sheet according to the product ID, the product ID will already be in the order sheet, then
    I would like to multiply the cost of each product in the order by its quantity which will already be given in the excel sheet
    and create a new column in total cost for the product but there's
    too many of the orders and products and manually inserting by myself is really physically taxing is there any function or any way in
    Excel to make my work easier?

    Also, after inserting the costs into the order sheet, I would like to compile the total costs for each order and then insert the total costs
    into the total profits sheet according to the order ID of course, after that there will be a total release amount column to subtract the total
    cost and create a new column called total profits for each order so again is there any other way of making this work easier?

    I have learnt Python programming albeit not at industry level yet so if there is no function in excel that can help me with this,
    are there any other ways I can explore using Python programming on Excel?

    Below are the excel sheets I mentioned

    Help would be very much appreciated as you saved my sanity
    Thank you
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    Re: Complete newbie that doesnt know what category this problem should be in, very sorry

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Complete Newbie Here, Grocery List Help
    By CassieBurt in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-21-2016, 11:59 AM
  2. A complete newbie.
    By Adammulti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-07-2015, 12:06 PM
  3. Almost a Complete Newbie with Excel
    By 1C0sm01 in forum Excel General
    Replies: 2
    Last Post: 07-19-2015, 09:34 PM
  4. Replies: 5
    Last Post: 07-24-2014, 02:04 PM
  5. A complete newbie - please help with a password problem
    By alexisemma31 in forum Excel General
    Replies: 9
    Last Post: 08-02-2012, 02:36 AM
  6. complete macro newbie
    By savfam02 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2010, 09:14 PM
  7. If then:complete newbie
    By Cydney in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2009, 01:31 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1