I have a list of items in one column that I need to be cut and pasted into a certain column based on the value of the cell. I have attached a simplified example of what I am trying to do. My beginning data is on "Names" sheet, the list of people on teams as it should be is on "Teams" sheet and the final result based original data on "Names" is located on "Final".
Thanks in advance!
Attachment?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I'm sorry. Here it is.
Thank you!
Here is one way to do it.
Please Login or Register to view this content.
Your code works perfect but I should have said that there is more data in the columns to the right so I need two columns inserted on the "Names" sheet after column A and the results to be displayed on that sheet not a separate one. Picky aren't I. Maybe someday I will understand enough to do it myself.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks