Copying rows from one sheet to another....

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying from one sheet to another 7
Match and delete rows on two different sheets from reference numbers 4
Multiple Sheet copying 8
Copying cells from one sheet to another 5
How to Add columns if a condition exists 1
COUNT rows on external sheet if between date range 3
Function or Formula help - get data from another sheet 10
Losing rows that reference data from another worsheet 1

Top