I am in Sales, I am building a spreadsheet that I can input all of my
prospects information in Sheet 1, and as they want to continue to do
business, I will turn a cell from N to Y, and when it gets changed to Y, I
want all that persons information to get shifted to another Sheet.

"Charles Harmon" wrote:

Rob,

It can be done. What and where is your criteria? Where do you want it to go?

Charles
"Rob" wrote in message
...
My question is if I have one worksheet with all of my information, and I
want
to extract certain data based on criteria, and cut and paste only that
data
into another worksheet, is this possible? If so how would I do it?