Hi would anyone have a macro that would copy the whole row and the 3 rows under to the next available row to a worksheet called "INTERESTS"
If the word "try" or the numbers 1,2,3 is found in column "J ", or the words " trs " or " trp "is found in column "Z"
In column "Z" the words "trs" and "trp" are made via forumla =IF(D1="yes","trs","trp")
Could it run on 50 sheets,the sheets are named 1,2,3,4,5,6,7 and so on
Example Z4 = trs , rows Z4 to Z7 would copy to sheet "INTERESTS"
Thanks
If the word "try" or the numbers 1,2,3 is found in column "J ", or the words " trs " or " trp "is found in column "Z"
In column "Z" the words "trs" and "trp" are made via forumla =IF(D1="yes","trs","trp")
Could it run on 50 sheets,the sheets are named 1,2,3,4,5,6,7 and so on
Example Z4 = trs , rows Z4 to Z7 would copy to sheet "INTERESTS"
Thanks