Hi
I have a sheet where in i am inputting data in to 5/6 columns and there could be many rows (List kind of).
Ex:
Sno. Activity Actor Remarks1 Remarks2
1 xyz Ken dddddddd eeeeee
2 abc Sys rrrrrrrrrrrrr sssssss
3
4
5
So from the above data whenever i input "Sys" under "Actor" column, The entire row no 2 has to be copied to another sheet (say Sheet2). and it should copy/append all the rows where ever Actor = "Sys" to Sheet 2.
Bookmarks