View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
burlybo burlybo is offline
external usenet poster
 
Posts: 1
Default Simple copy rows with certain value to new sheet

I have been looking everywhere for code to simply copy the rows from on
sheet that have a certain value in column K to a new sheet. I can'
find the code and I'm fairly new to this stuff.

I found out how to turn the cells with the value I'm looking for red
but I couldn't get the rows to copy into a new sheet.

Is this easy? It seems to me it should be easy, right? Should I use
select statement

--
Message posted from http://www.ExcelForum.com