+ Reply to Thread
Results 1 to 14 of 14

Importing data into a packing list

  1. #1
    Registered User
    Join Date
    12-07-2016
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    7

    Exclamation Importing data into a packing list

    I currently have a large beast of as spreadsheet that I have to filter by market and hide empty cells to provide my shipping with a pack list for stores to kits these items by

    What I would ideally like, is to be able to populate a packing list/pick list based off the stores code that will A) give the department something more easier to go by. B) give the recipient a clear idea what is in the box.

    attached is my spreadsheet with the second page being the packing list Im trying to use.
    Attached Files Attached Files

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,057

    Re: Importing data into a packing list

    Sorry Clemmer,

    I am not sure what exactly should take place...

    What is it you would like to generate exactly, or what do you want to input (and what is the expected output).
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    12-07-2016
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Importing data into a packing list

    I'd need the data pulled in to look like this
    Where the job code and description are listed along with qty as per each stores code and each store does not necessarily get the same itemsJanuary 2017 POP Kit (1) (version 2).jpg

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    So what do you want to happen? Create a new sheet for each store?
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    Not sure what you are wanting to do. I'm guessing to create a sheet for each Packaging Slip.

    This will create the Packaging Slips
    Please Login or Register  to view this content.
    This will delete the sheets
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    05-02-2015
    Location
    calgary alberta
    MS-Off Ver
    2012
    Posts
    205

    Re: Importing data into a packing list

    very nice code, but to do all the reports you bug out on this line where you set the sheet name, correct me if im wrong though

    ActiveSheet.Name = Cells(8, "b").Value

    if im not mistaken it should be

    ActiveSheet.Name = Cells(rw, "b").Value

  7. #7
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    I ran the code a few times and it never skipped a beat. No I get the name of the sheet from cell b8 which is the ship to.

  8. #8
    Forum Contributor
    Join Date
    05-02-2015
    Location
    calgary alberta
    MS-Off Ver
    2012
    Posts
    205

    Re: Importing data into a packing list

    weird im not to sure why

  9. #9
    Registered User
    Join Date
    12-07-2016
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Importing data into a packing list

    That's exactly what I needed, thank you!

    When I run the script is errors out with error "9" Subscript out of range on this line

    Worksheets(shPackagingSlip).Cells(8, "b").Value = arrData(rw, 2)

  10. #10
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    Does it error out on the example workbook you uploaded?

  11. #11
    Registered User
    Join Date
    12-07-2016
    Location
    Dallas
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Importing data into a packing list

    Quote Originally Posted by mike7952 View Post
    Does it error out on the example workbook you uploaded?
    ...Too many windows opened! This works exactly as I needed thank you!

  12. #12
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    No problem, your welcome.

  13. #13
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    Now I don't know where you are getting Order Date, Order number or Job.

  14. #14
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Importing data into a packing list

    If your happy with the solution provided please mark this thread closed.

+ 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. [SOLVED] How to create a packing list from a distribution list
    By Night Worker in forum Excel General
    Replies: 5
    Last Post: 02-20-2013, 11:35 AM
  2. Need Help - Conditional Copy Paste to create a Packing List
    By mrlab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2012, 10:12 AM
  3. Packing list in excel
    By badboy4u in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-14-2012, 06:53 PM
  4. Packing List help
    By elpierro in forum Excel General
    Replies: 5
    Last Post: 06-26-2012, 10:24 PM
  5. From a global listing to a packing list (bad title sorry)
    By yannickhk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-03-2009, 08:38 PM
  6. Replies: 0
    Last Post: 08-22-2006, 05:25 AM
  7. Replies: 0
    Last Post: 08-22-2006, 05:15 AM
  8. [SOLVED] filtered sorted packing list report from data table
    By Lori H in forum Excel General
    Replies: 1
    Last Post: 07-22-2005, 09:05 AM

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