| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying rows from one sheet to another....
I have a large spreadsheet that I update weekly. Columns a:x and rows going
on forever. I need a way of copying rows that match the criteria to a new sheet. i.e if A=dave i need all the information from a:x to go to a sheet called dave. If no one can help i'm doomed to cut and paste! Help my sanity! P.S I have no idea about macros!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying rows from one sheet to another....
Have a look at Ron de Bruin's Copy/Paste/Merge VBA code examples.
http://www.rondebruin.nl/tips.htm Gord Dibben MS Excel MVP On Wed, 20 Jun 2007 14:18:48 -0700, Buyone wrote: I have a large spreadsheet that I update weekly. Columns a:x and rows going on forever. I need a way of copying rows that match the criteria to a new sheet. i.e if A=dave i need all the information from a:x to go to a sheet called dave. If no one can help i'm doomed to cut and paste! Help my sanity! P.S I have no idea about macros!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
| copying rows from next sheet over | Excel Discussion (Misc queries) | |||
| Copying whole rows to different sheet once found | Excel Discussion (Misc queries) | |||
| Copying selected rows to another sheet | Excel Worksheet Functions | |||
| How Can I copy a sheet that has hidden rows without copying the h. | Excel Worksheet Functions | |||
Hybrid Mode
