Sending rows to another sheet based on value of column A

L

Lindsey M

Hi everyone

I have a worksheet that has 7 colmuns worth of data (it relates to team
managers, of which there are approx 10 (name stored in column A) and other
info regarding there team members.
Each team manager is part of a service, e.g. Joe Bloggs is part of Revenues
so I want all the rows that contain Joe Bloggs in column A to be transferred
to the worksheet named Revenues.
This needs to be done by code, by poss using a Command Button?
Any ideas on this?

As always, help is extremely appreciated!!

Cheers
Lindsey
 

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

Sending rows to another worksheet based on value of cells in column A 5
Auto transfer data rows to other sheets when certain entries occur 7
Copy rows to new sheet based on value in column A 0
Need formulas for searching for a value in a table and returning row/column name 7
How do I look up which column a value is in? 7
Sorting Worksheet w/o breaking links to other sheets 0
Macro to copy row based on value into new sheet of same name 9
Return a value based on another sheet info 2

Top