Hi,

I would like to know how to code macro to select range of columns and
compare the value of each cell.Here is an example of the file. I want
to check TCIT column and if the value is "Y" copy the row to a seperate
Sheet.

1 4 TCIT Y/N 3 4 5 6
Maint or Proj
4 r N N/A N ??? Test
2 ??? Y P N t Test
4 r N N/A N ??? Test


Thanks for help

Vedula