+ Reply to Thread
Results 1 to 6 of 6

Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

  1. #1
    Registered User
    Join Date
    07-23-2014
    Location
    Houston, Texas
    MS-Off Ver
    2011
    Posts
    4

    Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    All-

    Please help. I am trying to build a spreadsheet that will allow me to copy line items from one worksheet to the next once I change the status of the line items in a certain column. My goal is to manually enter line items in to my "purchase order log" and then once I change "Item Received?" to "YES," I need that line item to copy directly to my "Receiver Log."

    Please see attached. I assume this will require writing macros and I'm not by any means an expert on macros. Please help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    I loaded this one into the file. Try it and see if it does what you want.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-23-2014
    Location
    Houston, Texas
    MS-Off Ver
    2011
    Posts
    4

    Re: Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    It is actually not allowing me to open to attachment you sent. It says the file can't be found.

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    Note: I changed from .xlsx to .xlsm

  6. #6
    Registered User
    Join Date
    07-23-2014
    Location
    Houston, Texas
    MS-Off Ver
    2011
    Posts
    4

    Re: Automatically Populating A WorkSheet with Line Items Once Status is Changes in Another

    Nevermind. It let me open it. I'm not sure what is making the items transfer to the receiver log though. What I'm trying to figure out is let's say for PO number 1, I change the cell under "Item Received" to "YES" then I want it to copy that entire row into "Receiver Log"

+ 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. Automatically Copying Line Items From One Worksheet to Another
    By vdaigl2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 02:34 PM
  2. Replies: 4
    Last Post: 10-12-2012, 01:36 AM
  3. Replies: 2
    Last Post: 10-11-2012, 08:53 AM
  4. Populating a form in excel from a different worksheet line by line
    By GhettoNarnia in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-07-2012, 06:51 PM
  5. Automatically populating cells in a worksheet based on other worksheet column
    By umayank in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2008, 12:33 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