| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move data to new sheet - rename sheet based on criteria ?
Hey guys, any help is appreciated. Here is my situation: I have a
spreadsheet with over 4000 rows of data. The data has the month end date in column A, but there is an arbitrary number of rows for each month end. Is there a way to move the rows of data that all have the same month end date to a new sheet named for the corresponding date. As there are over 10 years of month end data, this is quite arduous without a macro. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| Copy entire row to another sheet based on a criteria | Excel Discussion (Misc queries) | |||
| Need to look up value in another Sheet based on criteria in first sheet. | Excel Worksheet Functions | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Insert sheet, move to end, rename with cell data. | Excel Discussion (Misc queries) | |||
Threaded Mode
