+ Reply to Thread
Results 1 to 6 of 6

Transfer Data to another sheet automatically

  1. 06-21-2012, 09:41 AM #1
    jmisti2
    jmisti2 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Transfer Data to another sheet automatically

    Hi new here. Looking for some help. I've found other threads on the subject, but I guess I'm not Excel savy enough to interpret the code and change the necessary variables to what I need. I need to transfer a row of data from one sheet to another automatically when a certain criteria is met. I have attached my workbook here and explained my criteria.

    I need for the row(s) starting at Row 4 through Row 39, columns A-P on Sheet(Engineering Schedule) to move to Sheet(Production Schedule) when the current date(Cell P2) > than the date in each row(s) respective cell E(E4,E5,E6,...E39).

    Example: When P2>E4 move cells A4-P4 from Engineering Sheet to Production Sheet starting at first available row starting with Row 4. and so on.

    The code currently on there was from another thread on the subject. I dont know if it will be a good base or not?

    Project Production (TestCode).xlsm
    Reply With QuoteRegister To Reply
  2. 06-21-2012, 01:49 PM #2
    jmisti2
    jmisti2 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Transfer Data to another sheet automatically

    Shameless bump to see if anyone can help??
    Reply With QuoteRegister To Reply
  3. 06-21-2012, 02:11 PM #3
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data to another sheet automatically

    There are people who only use the "unanswered threads" tool to get a list of posts with no replies. When you bump your own thread, you take your thread off that list permanently. FYI.


    Anyway, in the vbeditor, insert a normal module (Insert > Module) and paste in the regular macro:
    Please Login or Register  to view this content.
    Now you can attach that to a button on your Engineering schedule, if you wish. Run it when you want to move the rows to the other sheet.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  4. 06-21-2012, 02:36 PM #4
    jmisti2
    jmisti2 is offline
    Registered User
    Join Date
    06-21-2012
    Location
    Baton Rouge, LA
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Transfer Data to another sheet automatically

    Thanks a bunch for the advice, and for the code. It works great!!!

    One more question though. Is there a way to have the rows still containing data in the original sheet, after the extraction, consolidate at the top?
    Reply With QuoteRegister To Reply
  5. 06-21-2012, 03:07 PM #5
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data to another sheet automatically

    Your sample data is pretty incomplete. I would think a real dataset would always have data in a particular column perhaps the first one. You should be able to add a "SORT" command at the bottom of the code that sorts that range of cells using the key column of your choosing, that would push the empty rows to the bottom of the range.
    Reply With QuoteRegister To Reply
  6. 06-21-2012, 03:14 PM #6
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Transfer Data to another sheet automatically

    Like so... but you may want to take out the hardcoded color banding...replace with color banding applied through conditional formatting based on row #

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1