T
tennisash
Our office has a total of 50+ salespeople and we are growing every
day. I am trying to automate getting a certain piece of information
added each month by using a macro. all of the information is stored
in
the 2007 Midyear Zone Reports and I need it to go into the Branch
Productivity Report. Below are the setups of the two worksheets.
Branch Productivity Report (Where the infromation is going) (10
columns, 12 rows of data)
Owning Net Revenue Covering Net Revenue Avg covering net
rev Other Net
Revenue Total Load Net Revenue Owned Count Owned per day
Covered Count
Covered per day Total loads
January
February
March
.....
November
December
2007 Midyear Zone Reports (Where the information is coming from) (14
columns, various number of rows per slspn)
Month Slpsn Zone Owning Net Revenue Covering Net
Revenue Avg covering
net rev Other Net Revenue Total Net Revenue Owned
Count Owned per day
Covered Count Covered per day Total loads Cov Rev Per Day
1 aaa Carrier $1,008.60 $8,629.48
$118.21 $0.00 $9,638.08 1 0 73
3 74 $392.25
2 aaa Carrier $165.00 $14,549.94
$139.90 $98.95 $14,813.89 2 0
104 5 106 $727.50
3 aaa Carrier ($1,051.09) $17,680.85
$127.20 $0.00 $16,629.76 3 0
139 6 142 $803.68
4 aaa Carrier $147.85 $16,081.93
$116.54 $210.19 $16,439.97 1 0
138 7 139 $784.48
5 aaa Carrier $535.00 $15,146.00
$104.46 $516.04 $16,197.04 4 0
145 7 149 $688.45
6 aaa Carrier $810.00 $15,342.40 $131.13 $566.73
$16,719.13 4 0 117 6
121 $730.59
3 ccc Customer $17,726.56 $0.00
$0.00 $17,726.56 100 5 0 0 100
$0.00
4 ccc Customer $19,813.46 $0.00
$0.00 $19,813.46 112 5 0 0 112
$0.00
5 ccc Customer $29,206.48 $0.00
$0.00 $29,206.48 143 7 0 0 143
$0.00
6 ccc Customer $28,475.40 $0.00
$0.00 $28,475.40 181 9 0 0 181 $0.00
As you can see slpsn aaa has been here the entire year, but slspn ccc
started in March. I need to be able to start slpsn ccc's data on the
march line. Anyone have any suggestions on how to do this?
There are no blank columns in the data source and the only blank rows
are being used to seperate each salesperson's data. Obviously, this
can be reformatted as needed.
thanks
day. I am trying to automate getting a certain piece of information
added each month by using a macro. all of the information is stored
in
the 2007 Midyear Zone Reports and I need it to go into the Branch
Productivity Report. Below are the setups of the two worksheets.
Branch Productivity Report (Where the infromation is going) (10
columns, 12 rows of data)
Owning Net Revenue Covering Net Revenue Avg covering net
rev Other Net
Revenue Total Load Net Revenue Owned Count Owned per day
Covered Count
Covered per day Total loads
January
February
March
.....
November
December
2007 Midyear Zone Reports (Where the information is coming from) (14
columns, various number of rows per slspn)
Month Slpsn Zone Owning Net Revenue Covering Net
Revenue Avg covering
net rev Other Net Revenue Total Net Revenue Owned
Count Owned per day
Covered Count Covered per day Total loads Cov Rev Per Day
1 aaa Carrier $1,008.60 $8,629.48
$118.21 $0.00 $9,638.08 1 0 73
3 74 $392.25
2 aaa Carrier $165.00 $14,549.94
$139.90 $98.95 $14,813.89 2 0
104 5 106 $727.50
3 aaa Carrier ($1,051.09) $17,680.85
$127.20 $0.00 $16,629.76 3 0
139 6 142 $803.68
4 aaa Carrier $147.85 $16,081.93
$116.54 $210.19 $16,439.97 1 0
138 7 139 $784.48
5 aaa Carrier $535.00 $15,146.00
$104.46 $516.04 $16,197.04 4 0
145 7 149 $688.45
6 aaa Carrier $810.00 $15,342.40 $131.13 $566.73
$16,719.13 4 0 117 6
121 $730.59
3 ccc Customer $17,726.56 $0.00
$0.00 $17,726.56 100 5 0 0 100
$0.00
4 ccc Customer $19,813.46 $0.00
$0.00 $19,813.46 112 5 0 0 112
$0.00
5 ccc Customer $29,206.48 $0.00
$0.00 $29,206.48 143 7 0 0 143
$0.00
6 ccc Customer $28,475.40 $0.00
$0.00 $28,475.40 181 9 0 0 181 $0.00
As you can see slpsn aaa has been here the entire year, but slspn ccc
started in March. I need to be able to start slpsn ccc's data on the
march line. Anyone have any suggestions on how to do this?
There are no blank columns in the data source and the only blank rows
are being used to seperate each salesperson's data. Obviously, this
can be reformatted as needed.
thanks