I Have Two sheet named "carcase"and " shutter". In carcase sheet I have three nos. Of columns and 800 nos. Of Rows, in second no. Of column I have name like carcase top, Front ,carcase back,Design element etc. Now I have to copy rows in second sheet which contains the cellname ="Front" in second column.
Try to scan one shell value and copy that entire row in other sh