I will try to explain this as well as possible.
Have three Named Ranges. These named ranges consist of multiple rows. They are complete rows. So in order to have multiple groups of these named ranges, they must be arranged vertically. heres an example of my datasheet. I have taken out many associates to save space.
b c d
1 Associates Feb
2 Month Goal 90
3 FullTime Goal 4
4 Altherr 1
5 Ayling 2
6 Bolin 4
7 Buntain 3
8 total 10
9 part time goal 3
10 Collins 11
12 Hower 2
13 Leslie 3
14 Total 16
15 DStatus Goal 2
16 Beebee 5
17 Buggerman 4
18 Chapman 2
19 Lazar 9
20 Total 20
Column D -N continue with the months, associate goals and the associate actuals. The total rows are Sum Functions. and in column O they are Sum Functions across the rwos to get the associate total for the year. Currently with this example, rows 4-7 are named FullTime, rows 10-13 are named PartTime, and rows 16-19 are named DStatus. What i need is a macro that inserts a new rown into the named range one row above the last associate in each range-. But i need the macro to be flexible that it understands that because i hired and thus added new assoicates, that it changes the location to insert the row based upon the corresponding number of rows in the range... Please help!
Have three Named Ranges. These named ranges consist of multiple rows. They are complete rows. So in order to have multiple groups of these named ranges, they must be arranged vertically. heres an example of my datasheet. I have taken out many associates to save space.
b c d
1 Associates Feb
2 Month Goal 90
3 FullTime Goal 4
4 Altherr 1
5 Ayling 2
6 Bolin 4
7 Buntain 3
8 total 10
9 part time goal 3
10 Collins 11
12 Hower 2
13 Leslie 3
14 Total 16
15 DStatus Goal 2
16 Beebee 5
17 Buggerman 4
18 Chapman 2
19 Lazar 9
20 Total 20
Column D -N continue with the months, associate goals and the associate actuals. The total rows are Sum Functions. and in column O they are Sum Functions across the rwos to get the associate total for the year. Currently with this example, rows 4-7 are named FullTime, rows 10-13 are named PartTime, and rows 16-19 are named DStatus. What i need is a macro that inserts a new rown into the named range one row above the last associate in each range-. But i need the macro to be flexible that it understands that because i hired and thus added new assoicates, that it changes the location to insert the row based upon the corresponding number of rows in the range... Please help!