excel vba - create a macro to cut a row on sheet1 based on the "False" criteria in the same row of sheet3 -


i new macros have managed create 1 using record macro function not work scenario

i have workbook paste rows of data 2 tables in different sheets , have table in 3rd sheet checks if corresponding cells match i.e. sheet1 j3 matches sheet2 j3 rec table show "true"

i put in macro using record macro sort both tables same columns in line each other if have same data rows, issue 1 side have more rows other because have include data rows may not required report , after sorting these can end anywhere in table , throw out data doesn't match properly

to desired results work manually , start top of sheet2 (it table has rows) , cut out first row has multiple "false" readings , paste bottom of sheet2 data, mean rows below 1 until next data row match "true"

i repeat until rows of data @ bottom of sheet 2 , above should matching

can me put in macro cut , insert row paste, have 1 one ensure rows below cut 1 allowed match before looking next "false" row cut , insert below

the cell columns need false activate cut , paste of row rec table j, k & m

thanks


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

.htaccess - ERR_TOO_MANY_REDIRECTS htaccess -