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

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 <(E-Mail Removed)>
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!!