Thread: Copy/paste rows to new sheet based on cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
taylor taylor is offline
external usenet poster
  
Posts: 32
Default Copy/paste rows to new sheet based on cell value
I have a large spreadsheet in which one column returns "check status",
"visit", or "Send Letter 2" based on an IF/THEN formula. Is there a way to
automatically select those rows containing "check status", "visit", and "Send
Letter 2", copy the row and paste it onto a new sheet? Do I need a macro for
this?
Reply With QuoteReply With Quote