| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move data from sheet to sheet based on ColA
Hi everyone. If I have a sheet called Data, is there a way to have
vba scan all of column A, identify unique values in column A, and then parse out the entire rows into new sheets? So for instance, if the values in ColumnA are Blue, Green and Yellow. VBA wold create 3 new sheets. In the Blue sheet, there would only be records that had Blue in Column A, and so forth. The only catch is the number of unique values in ColA can change from month to month. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| How do I move daily data from one sheet to a 'yearly sheet' | Excel Worksheet Functions | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| Move data from on sheet to another based on month | Excel Programming | |||
![Steve[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
