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
Post a Comment