| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to copy multiple rows to separate worksheets
Hi:
I have a range of data on a single worksheet: 1 name1 address1 1 name2 address2 2 name3 address3 3 name4 address4 3 name5 address5 3 name6 address6 I have to copy all rows with 1 in column A to a separate worksheet called 1, and the same for "2" and "3". I'm a bit iffy on how to use the VLOOKUP (is it relevant here?). I have 1500 lines of data so am looking to automate. thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Viewing multiple rows of worksheets in a workbook | Excel Discussion (Misc queries) | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
| Create a Macro that will copy the rows that have a value < 0 | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| inset rows and copy formatting , excel macro | Excel Discussion (Misc queries) | |||
Threaded Mode
