Hello,
I have a document with over 1000 rows. I want to copy yellow areas ( Which has "1" value in the "A" Column. and and it will copy the columns until "MISC" word, For example first area is from "B5 to J9" )
and paste them to another sheet as transposed. I need a VBA code which runs successively.
I will be glad for your help.
***First picture is from main file, and the second one is the expected result.
Bookmarks