Creating a macro to line up data in 2 worksheets.
 

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)
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)

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 lines
are being used to seperate each salesperson's data. Obviously, this
can be reformatted as needed.

thanks