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")))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MACRO for moving rows from one worksheet to another 3
How to move rows from one sheet to another sheet (macro) 1
Auto Copy Data from one worksheet to another 1
Macro to Compile Data from Different Sheets 2
Search , then copy and paste from multiple worksheets. VBA help 1
Create if partial match then copy and paste data from one cell to another 1
Excel Move or Copy Stopped Working? 0
Somewhat complex code to copy data from one sheet to another 9

Back
Top