+ Reply to Thread
Results 1 to 3 of 3

Macro needed to cut and paste in one table based on False criteria in a diferent table

  1. #1
    Registered User
    Join Date
    06-28-2017
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    13

    Macro needed to cut and paste in one table based on False criteria in a diferent table

    Hi, I am very new to Macros so currently have only managed to create one using the record macro function which will not work with this scenario

    I currently have a workbook where I paste rows of data into two tables in different sheets and have a table in a 3rd sheet which checks if the corresponding cells match i.e. sheet1 J3 matches sheet2 J3 then my rec table will show "TRUE"

    I put in a macro using record macro to sort both tables by the same columns so they will be in line with each other if they have the same data rows, my issue is that often one side will have more rows than the other because I have to include extra data rows which may not be required for my report and after the sorting these can end up anywhere in the table and will throw out the data so it doesn't match properly

    to get my desired results I currently work manually and start from the top of sheet2 (it is always this table which has the extra rows) and cut out the first row which has multiple "FALSE" readings and paste it to the bottom of the sheet2 data, this will then usually mean that all the rows below this one until the next extra data row will match "TRUE"

    I will repeat this until all the extra rows of data are at the bottom of sheet 2 and everything above this should then be mostly matching

    can anyone help me to put in a macro to do this cut and insert row paste, it would have to do it one by one to ensure the rows below the cut one are allowed to match before looking for the next "false" row to cut and insert below

    the cell columns that would all need to be false to activate the cut and paste of a row would be rec table J, K & M

    Thanks

  2. #2
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: Macro needed to cut and paste in one table based on False criteria in a diferent table

    could you upload a sample workbook?

  3. #3
    Registered User
    Join Date
    06-28-2017
    Location
    singapore
    MS-Off Ver
    2010
    Posts
    13

    Re: Macro needed to cut and paste in one table based on False criteria in a diferent table

    unfortunately I cannot upload any files from my work PC

+ 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. Macro: Copy/cut all rows matching criteria, and paste into specific Table/sheet
    By Andrewjs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2017, 03:55 PM
  2. [SOLVED] Please help: VBA/macro needed to Vlookup, if false, copy/paste to another sheet/same book
    By Jeannine in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2016, 01:27 PM
  3. Replies: 3
    Last Post: 10-01-2015, 11:09 AM
  4. Count records in table based on criteria, select and paste to a new spreadsheet
    By thisguy4000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2014, 09:43 AM
  5. Macro to copy a table and paste in another table (based on certain conditions)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 01:14 PM
  6. Replies: 2
    Last Post: 04-16-2013, 06:17 AM
  7. Macro Help Needed - Link Pivot Table Filter to Regular Table AutoFilter
    By ycx1129 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2011, 12:54 PM

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