Divide and Conquer

[clarka9]

I am trying to automate a sheet that will be updated continously as I move on, but I will need the code to break the ranges out for each on the next sheet.
Thanks ALOT!!!!!!!......

First Name</SPAN>	Last</SPAN>	Assign Begin Dt</SPAN>	Assign Retn Dt</SPAN>
Anthony</SPAN>	Teft</SPAN>	1/7/2013</SPAN>	5/31/2013</SPAN>
John</SPAN>	Mahoney</SPAN>		12/31/2014</SPAN>
Adam</SPAN>	Sweet</SPAN>	10/13/2008</SPAN>	12/31/2013</SPAN>
Gregory</SPAN>	Klock</SPAN>	3/11/2013</SPAN>	3/20/2013</SPAN>
Kevin</SPAN>	Sauve</SPAN>	3/11/2013</SPAN>	3/24/2013</SPAN>
Paul</SPAN>	Barnes</SPAN>	12/3/2012</SPAN>	12/23/2012</SPAN>
Matthew</SPAN>	Seibert</SPAN>	3/11/2013</SPAN>	3/24/2013</SPAN>

<TBODY>
</TBODY>

 

[clarka9]

The conditional formatting was due to finding duplicates.
Didnt think the date formate would make that much of a significant difference.
Should I change it back?
How can I resolve the issue?

 

[hiker95]

clarka9,

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[clarka9]

Bump

 

[clarka9]

BUMP!
The Macro stops cell 105.
Thanks for your help!

 

[clarka9]

Hiker95,

Since you were the orginator of this code, all I am asking is for you to help me with this error msg that I am recieving
" With wR.Cells(nr + 1, 3).Resize(m - 1)"
When you ran the Marco, did you receive that message?

 

[hiker95]

clarka9,

I have attempted to solve your every changing request, but, I have far exceeded the normal amount of time I allocate for solving problems/requests from web sites like MrExcel.

Click on the Reply to Thread button, and just put the word BUMP in the post. Then, click on the Post Quick Reply button, and someone else will assist you.