+ Reply to Thread
Results 1 to 4 of 4

Macro to Copy and Paste if condition is met

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Macro to Copy and Paste if condition is met

    Hello Forum,

    I need a macro that would look at spreadsheet called Tool Test Tab Review column J7 to J infinity and if column P7 to P infinity is < column J7 to J infinity the macro would copy the row starting a A7:B7:C7:D7:E7:F7:G7:J7 Overpayment Tab cell H7: I7: and L7 and paste it to Data Tab starting at row A18 and move to next row. I also need the boarders added for each row pasted to the Data tab. Important note after a row is pasted the yellow row must remain being pushed down each time a new row is added when the condition is met.
    Please see attachment of the spread sheet named Tool Test. Thank you for your help in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Macro to Copy and Paste if condition is met

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Macro to Copy and Paste if condition is met

    Hi daffodil11

    The Macro works great, but it only did one row on the Review Tab. When I include information on the next row on the Review Tab that information is not copied and pasted over to the Data sheet. Feel free to add any information on the next row on the Review Tab to see for your self. I truly appreciate your help and thank you again.

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Macro to Copy and Paste if condition is met

    I see. I've modified the code to use a hardcoded start at 17, and cycle upwards to avoid the error.

    Please Login or Register  to view this content.

+ 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] Copy and Paste Row If Condition is Met
    By mattman123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2013, 01:26 PM
  2. Macro to copy from one sheet and paste in another if a condition is met.
    By dlholland1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-29-2013, 09:41 AM
  3. Excel Macro to insert two rows based on condition and copy and paste multiple cells
    By mannabhalo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-13-2012, 12:56 PM
  4. Copy paste based on a condition
    By jay36429 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 01:36 PM
  5. Copy and Paste Special Values Macro ignoring cells with specific condition
    By chendriks47 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-06-2011, 03:01 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