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!!

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!!