Copy data from one worksheet to another

  • Thread starter Thread starter Stacey
  • Start date Start date
S

Stacey

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.
 
hi

You said that you
"want to copy the rows (B-M) that contain the class to its corresponding
sheet"

B-M is a colume rather than row. so really don't undertand what you want.

Howevery, you might use formula to set as a criteria showing the
data/information related tot he tab name.

Below function help to retrieve the tab name for the sheet, so it may be
help to you
=MID(CELL("filename"),(SEARCH("]",CELL("filename"),1))+1,LEN(CELL("filename")))
 
Back
Top