Divide and Conquer

clarka9

New Member
Joined
Mar 21, 2013
Messages
28
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>
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Here is an example.
I need to show the level as well. The levels are in thier own column.
Thanks!

First Name</SPAN>Last Name</SPAN>Assign Dt</SPAN>Assign Retn Dt</SPAN>Level</SPAN>
Bob </SPAN>Johnson</SPAN>1/7/2013</SPAN>5/31/2013 </SPAN>5</SPAN>
Bob </SPAN>Johnson</SPAN>1/3/2013</SPAN>12/31/2014</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>10/13/2008</SPAN>12/31/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>3/11/2013</SPAN>3/20/2013</SPAN>4</SPAN>
Bob </SPAN>Johnson</SPAN>3/11/2013</SPAN>3/24/2013</SPAN>4</SPAN>
Bob </SPAN>Johnson</SPAN>12/3/2012</SPAN>12/23/2012</SPAN>4</SPAN>
Bob </SPAN>Johnson</SPAN>3/11/2013</SPAN>3/24/2013</SPAN>4</SPAN>
Bob </SPAN>Johnson</SPAN>12/10/2012</SPAN>6/6/2013</SPAN>4</SPAN>
Bob </SPAN>Johnson</SPAN>3/4/2013</SPAN>3/31/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>1/7/2013</SPAN>3/24/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>2/11/2013</SPAN>3/15/2014</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>2/11/2013</SPAN>3/15/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>1/7/2013</SPAN>3/3/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>1/7/2013</SPAN>3/24/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>3/4/2013</SPAN>3/4/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>1/21/2013</SPAN>3/31/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>1/7/2013</SPAN>3/31/2013</SPAN>2</SPAN>
Bob </SPAN>Johnson</SPAN>5/7/2012</SPAN>5/8/2013</SPAN>2</SPAN>

<TBODY>
</TBODY>
 
Upvote 0
clarka9,

How about taking your first screenshot, and expanding its data, to the view you posted for Bob Johnson?

And, what is the logic for determining the Level?

What is the worksheet name that belongs to the first screenshot?

What is the worksheet name that belongs to the second screenshot?
 
Upvote 0
There is no further post for Bob Johnson.
The level play into the chart I will create.
The first screenshot name will be "Data"
The second will be "Result".
I can change the information in the Macro later.
Thanks!
 
Upvote 0
clarka9,

If we start with this:


Excel 2007
ABCD
1First NameLastAssign Begin DtAssign Retn Dt
2AnthonyTeft1/7/20135/31/2013
3JohnMahoney12/31/2014
4AdamSweet10/13/200812/31/2013
5GregoryKlock3/11/20133/20/2013
6KevinSauve3/11/20133/24/2013
7PaulBarnes12/3/201212/23/2012
8MatthewSeibert3/11/20133/24/2013
9
Data


What should this worksheet look like (manually formatted by you, and, what determines the Level):


Excel 2007
ABCDE
1First NameLastAssign Begin DtAssign Retn DtLevel
2
3
4
5
6
7
8
9
10
Result



If you can not explain the logic for copying to the above worksheet, and, can not explain the logic for determining the Level, then:

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.
 
Upvote 0
First Name</SPAN>Middle</SPAN>Last</SPAN>DeptID</SPAN>Country</SPAN>Date </SPAN>Level</SPAN>
Anthony</SPAN>J.</SPAN>Teft</SPAN>F500</SPAN>AFG</SPAN>1/7/2013</SPAN>5</SPAN>
Anthony</SPAN>J.</SPAN>Teft</SPAN>F501</SPAN>AFG</SPAN>2/7/2013</SPAN>5</SPAN>
Anthony</SPAN>J.</SPAN>Teft</SPAN>F502</SPAN>AFG</SPAN>3/7/2013</SPAN>5</SPAN>
Anthony</SPAN>J.</SPAN>Teft</SPAN>F503</SPAN>AFG</SPAN>4/7/2013</SPAN>5</SPAN>
Anthony</SPAN>J.</SPAN>Teft</SPAN>F504</SPAN>AFG</SPAN>5/31/2013</SPAN>5</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5375</SPAN>AUS</SPAN>10/13/2008</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5376</SPAN>AUS</SPAN>11/12/2008</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5377</SPAN>AUS</SPAN>12/12/2008</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5378</SPAN>AUS</SPAN>1/11/2009</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5379</SPAN>AUS</SPAN>2/10/2009</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5380</SPAN>AUS</SPAN>3/12/2009</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5381</SPAN>AUS</SPAN>4/11/2009</SPAN>2</SPAN>
Adam</SPAN>D</SPAN>Sweet</SPAN>5382</SPAN>AUS</SPAN>5/11/2009</SPAN>2</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=4><COL><COL><COL span=3></COLGROUP>
 
Upvote 0
clarka9,

Where is the Yellow information coming from?


Excel 2007
ABCDEFG
1First NameMiddleLastDeptIDCountryDateLevel
2AnthonyJ.TeftF500AFG1/7/20135
3AnthonyJ.TeftF501AFG2/7/20135
4AnthonyJ.TeftF502AFG3/7/20135
5AnthonyJ.TeftF503AFG4/7/20135
6AnthonyJ.TeftF504AFG5/31/20135
7AdamDSweet5375AUS10/13/20082
8AdamDSweet5376AUS11/12/20082
9AdamDSweet5377AUS12/12/20082
10AdamDSweet5378AUS1/11/20092
11AdamDSweet5379AUS2/10/20092
12AdamDSweet5380AUS3/12/20092
13AdamDSweet5381AUS4/11/20092
14AdamDSweet5382AUS5/11/20092
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top