+ Reply to Thread
Results 1 to 5 of 5

Transfering orderdata into urgent demand list

  1. #1
    Forum Contributor
    Join Date
    03-14-2005
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    329

    Transfering orderdata into urgent demand list

    Hello.

    In our company we send purchase orders to our suppliers but when we are in a hurry we need the supplier to reprioritize in what order they should produce the parts we have ordered. The supplier would like to not only have the prioritized part number and how many but also the purchase order this quantity is connected to.

    Based on this I need the purchasing data to be transfered with a formula based on the quantity we want to prioritize per part number.

    In the attached file you can see this described better so you understand what I need help with.
    Bok1.xlsx


    I hope someone knows how to to this.

    /Anders

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Transfering orderdata into urgent demand list

    Hi Anders,

    Have you considered using a PIVOT TABLE?

    Something like this : a94andwi - Bok1.xlsx

    I hope this helps, please let me know!

    Regards,

    David


    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".


  3. #3
    Forum Contributor
    Join Date
    03-14-2005
    Location
    Sweden
    MS-Off Ver
    Office 365
    Posts
    329

    Re: Transfering orderdata into urgent demand list

    Not exactly how I want it but maybe a solution.... I need to check this...

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: Transfering orderdata into urgent demand list

    Is there any priority of picking order? For example, 110:4pcs, 111:2pcs,112:3pcs. If urgent demand is 3 pcs, which option should be? 110: 3pcs (in order of order number), or 112: 3pcs (packing policy). Another case: urgent demand: 5pcs=111(2pcs)+112(3 pcs) or =110(4pcs)+111 (1pc)
    Quang PT

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Transfering orderdata into urgent demand list

    m12=IF(SUMPRODUCT(SUMIFS($C$12:$C$24,$A$12:$A$24,$K12,$B$12:$B$24,$L12:L12))<$L12,INDEX($B:$B,SMALL(INDEX(($A$12:$A$24<>$K12)*10^10+ROW($A$12:$A$24),0),COLUMNS($M12:M12))),"")
    Please Login or Register  to view this content.
    Try this and copy across
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. Drop down list:URGENT
    By Doongchen in forum Excel General
    Replies: 5
    Last Post: 03-25-2015, 04:16 AM
  2. [SOLVED] Drop down list and transfering data to another sheet automatically
    By cwby44 in forum Excel General
    Replies: 9
    Last Post: 12-31-2012, 10:07 AM
  3. [SOLVED] Userforms transfering list Listbox.list's
    By Bishonen in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-08-2012, 07:18 AM
  4. Drop Down List Box HELP URGENT PLEASE!
    By lucasprss in forum Excel General
    Replies: 12
    Last Post: 08-03-2012, 11:32 AM
  5. Transfering a list of data based on a list selection
    By smirish in forum Excel General
    Replies: 7
    Last Post: 03-07-2012, 04:28 PM
  6. Transfering a list of data based on a list selection
    By smirish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2012, 03:26 PM
  7. transfering multi selected list box in userform to one cell in worksheet
    By isatrist in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-04-2011, 12:35 AM

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