Apologies if this looks messy.
I recieve a table in Excel from a coleague each day like this(minus the dots).
Name...........Volume.....Distance.....Bracket
Tom.............34,000.....16.............11-20
Michael.........30,000.....18.............11-20
James..........29,000......18............11-20
Tim..............45,000.....22.............21-30
John............15,000......24............21-30
Joe..............25,000......42............41-50
Kevin...........16,000......48............41-50
I need to distribute the rows to line up along a preset column of brackets that looks like this
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
11-20 Tom.............34,000.....16.............11-20
11-20 Michael.........30,000.....18.............11-20
11-20 James..........29,000......18............11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
21-30 Tim..............45,000.....22.............21-30
21-30 John............15,000......24............21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
41-50 Joe..............25,000......42............41-50
41-50 Kevin...........16,000......48............41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
The column of brackets needs to stay like this as there are calculations that are run off these exact positions.
At the moment I am dragging and dropping the rows. I need a faster way to do this.
I've tried using a look-up table but it involves endless ammounts of IF statements. Maybe VB could help or another formula or nest of formulas.
Apologies if the answer is obvious.
Colm
I recieve a table in Excel from a coleague each day like this(minus the dots).
Name...........Volume.....Distance.....Bracket
Tom.............34,000.....16.............11-20
Michael.........30,000.....18.............11-20
James..........29,000......18............11-20
Tim..............45,000.....22.............21-30
John............15,000......24............21-30
Joe..............25,000......42............41-50
Kevin...........16,000......48............41-50
I need to distribute the rows to line up along a preset column of brackets that looks like this
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
0-10
11-20 Tom.............34,000.....16.............11-20
11-20 Michael.........30,000.....18.............11-20
11-20 James..........29,000......18............11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
11-20
21-30 Tim..............45,000.....22.............21-30
21-30 John............15,000......24............21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
21-30
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
31-40
41-50 Joe..............25,000......42............41-50
41-50 Kevin...........16,000......48............41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
41-50
The column of brackets needs to stay like this as there are calculations that are run off these exact positions.
At the moment I am dragging and dropping the rows. I need a faster way to do this.
I've tried using a look-up table but it involves endless ammounts of IF statements. Maybe VB could help or another formula or nest of formulas.
Apologies if the answer is obvious.
Colm