View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Prabu Prabu is offline
external usenet poster
 
Posts: 7
Default Copy Data between Worksheets

Hi All,

I'm new to Macro Code. I need a help. I've 2 work sheets(Sheet4 and Sheet5).
I've some data in Sheet4 which i've colored with 2 different colors(Say Red
and Green). Now i would like to move(copy and paste) only data which are in
Red color to another sheet(Sheet5). Can somebody help me?

Thanks in advance,
JP