View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Buyone Buyone is offline
external usenet poster
 
Posts: 16
Default 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!!