Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from one worksheet to another
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")) ) "Stacey" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy/pasting data into a worksheet and then sorting worksheet | Excel Programming | |||
Copy data in multiple worksheet tabs into one worksheet | Excel Programming | |||
copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
copy data in a cell from worksheet A to worksheet B | Excel Discussion (Misc queries) | |||
Copy Modified Worksheet 1 Data to Worksheet 2 | Excel Programming |