View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stacey Stacey is offline
external usenet poster
 
Posts: 55
Default Copy data from one worksheet to another

I have a workbook that has different classifications based on a dates
(Classifications = Red, Green, Yellow). On the cumulative sheet I have all
and then I have a separate sheet for each class. I want to copy the rows
(B-M) that contain the class to its corresponding sheet (keeping the
cumulative sheet populated). I have a formula to notate which row contains
the appropriate color (Column A). Each sheet has the same header as the
cumulative sheet.