| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Rows With Same Value into a new Worksheet
Hey right now I have a huge excel sheet with like 250 columns and
there are about 250 rows but I need the macro to go up to 1500 because I will be getting more data. In the column "i" I have different strings such as "Burger King". I need a macro that will copy every row in the sheet that is the value of Burger King in "i" for example to its own sheet entitled that value. Can someone help me out please? I tried a few things I found by searching but they didn't work. Thank you very much! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF in between rows | Excel Worksheet Functions | |||
| copy from B worksheet to A worksheet with NO repeated data | Excel Discussion (Misc queries) | |||
| copy non-consecutive rows | Excel Discussion (Misc queries) | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
