+ Reply to Thread
Results 1 to 6 of 6

Trying to create a pick list from an order

  1. #1
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Trying to create a pick list from an order

    I have a multi page workbook with items in different categories. I have created a sheet that pulls in any row that had a number in the ordered column. What I need now is a way to have another sheet create a pick list from the order sheet. I only need three of the cells in each row brought over but the cells in the pick list sheet are in different places than the order sheet. For example, on the order list I have columns A-G with headings for item#, description, price, etc. I only need to bring in the item#, description and number ordered to the pick list. Can someone please help me with the code for this? I've attached a small sheet that demonstrates what I have so far. Thanks in advance for any help!Test Order.xlsm

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Trying to create a pick list from an order

    Try

    Please Login or Register  to view this content.
    on the Sheet3 (pick list) code tab
    Martin

  3. #3
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Re: Trying to create a pick list from an order

    That seems simple enough, but when I go the sheet nothing is happening. I put this in as the only code for the Pick List sheet. Any ideas?

  4. #4
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Re: Trying to create a pick list from an order

    Also, will this keep the information together that comes from each row? I need to make sure that they don't somehow get rearranged.

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Trying to create a pick list from an order

    Can you try putting breakpoint on the first line in the code to see if it is firing at all?

  6. #6
    Registered User
    Join Date
    07-14-2011
    Location
    Sevierville, tn
    MS-Off Ver
    Office 2010 Professional
    Posts
    46

    Re: Trying to create a pick list from an order

    Not sure what I did, but I changed some of the code around on the "ordered" sheet and all of a sudden the code you gave me fired right up. I really appreciate the code. Not a total newb to Excel or the VBA, but it's been a while since I messed with it. Thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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