+ Reply to Thread
Results 1 to 3 of 3

Need Help - Conditional Copy Paste to create a Packing List

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Need Help - Conditional Copy Paste to create a Packing List

    I have a multi-tab spreadsheet and want to auto-populate data from one sheet to another based on IF / THEN.

    On my first tab, 'Bill of Materials Pricing', IF Qty Exists in column i, THEN I would like to write the following fields from that particular row onto my 'Packing Sheet' tab in the first blank row available:

    PartNumber, Description, Quantity

    For example, if in 'Bill of Materials Pricing' cell I9, I enter a quantity of "3":
    I want the Part Number from that row written to 'Packing Sheet' B18
    I want the Description from that row written to 'Packing Sheet' B19
    I want the Quantity from that row written to 'Packing Sheet' B20

    TOD3060 30" x 60" Table Frame 3

    Then I want the macro to look for each additional cell with quantity in column I and do the same - adding the Part Number, Description and Qty to the next blank line on the 'Packing Sheet'.

    See my attached spreadsheet...DSG TRANSFER MASTER v7.xlsAnyone help me out on this one?

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Need Help - Conditional Copy Paste to create a Packing List

    Hi mrlab

    Welcome to the Forum!

    Check your cell references...are they correct?
    I want the Description from that row written to 'Packing Sheet' B19
    I want the Quantity from that row written to 'Packing Sheet' B20
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    12-11-2012
    Location
    MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Need Help - Conditional Copy Paste to create a Packing List

    oops - thanks...it is actually displaying what I would like to see happen through use of a script. Therefore:
    Part Number would get written to 'Packing Sheet' B18
    Description would get written to 'Packing Sheet' C18
    Quantity would get written to 'Packing Sheet' D18

    If this can be executed with use of a "Create Packing List" function/button - I guess it might eliminate issues with modifications during the process. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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