How Can I Move Textual Data?

Is it possible to move textual data in one worksheet based on data in another?

In the attached workbook Example.xls, I have a worksheet called List of Employees. If the employee is on that list, I want their e-mail to be moved in the worksheet called Original from the "Employees All time" cell to the "Employees Still Here" cell.

How can I do this? Please see attached Excel workbook. I have also included an example result within the workbook called Example Result.

Is this something like you are after?

Ok, that makes this a whole new ball game. Try this.

This is a cross-post.

Thanks abousetta, I have her file completed anyway.

Since you are probably new to forums, I will not reply to your ignorant comment. Maybe you should have a look at the following link for an explanation of what you did wrong. http://www.excelguru.ca/content.php?184

And just so you are aware, I will have the negative rep you gave me reversed. You don't get to break the rules and complain that you got your hand caught in the cookie jar. If you don't like then maybe you will be happy get your solutions from a consultancy service rather than free forums.

jcholla, abousetta is correct in posting your cross post. It is very frustrating to spend time on an answer only to have it already answered somewhere else. In this case it was not answered on the other site so no harm done. I can hope you will see where abousetta is coming from and understand that his post was not useless. It is just good forum etiquette and as abousetta stated, it is nothing to be offended about if you are new to these types of forums, just being careful in future is all that is required. Thanks for the rep and Cheers.

@jcholla... you obviously don't get it. We are here to help, but it doesn't help anyone if you already had an answer. Why did you post at Mr. Excel if JapanDave was already working hard on providing you with a solution. Did you think he would not be able to help you or that this problem was above his understanding or abilities? Why were you not clear that you are cross-posting? Why hide it? Did you tell the Mr. Excel members about the initial solution that you got here? Of course these are all rhetorical questions and just so you know, the top people here are the same ones at other sites. If you don't believe me then got the Microsoft Excel MVP site and check out some of the profiles. You will notice that they post on similar sites.

Another broken rule... don't start a new thread with the same question:

http://www.excelforum.com/excel-gene...html?p=2797154

and of course, cross-posted

http://www.mrexcel.com/forum/showthr...87#post3159187

jcholla

The Forum Rules are there to be followed.