Thread: Help needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ramgopal.vedula@gmail.com is offline
external usenet poster
 
Posts: 1
Default Help needed

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