| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop cells - get all rows with matching data - paste into different wb
ok - i think i got most of what i am looking for in the title!!
I have a workbook, i have data in rows - (cols A:CJ) Loop cells (col E)- get all rows with matching data in where the first 4 characters = ("XXXX") - paste all of these into different wb, worksheet ( "FAR" ) then again for ("YYYY") etc.... can anyone show me some quick code that i can throw in??? note: the workbook is already open, and is referenced in the code already.... (reply to |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Matching Data Within Numerous Rows | Excel Worksheet Functions | |||
| count number of rows with 2 matching text cells | Excel Worksheet Functions | |||
| Find matching date in another worksheet, copy and paste data | Excel Discussion (Misc queries) | |||
| Can I merge data in 2 sheets matching rows of data by last name? | Excel Discussion (Misc queries) | |||
| constructing a copy-paste loop that skips rows | Excel Programming | |||
Threaded Mode
