Duplicate rows inserted

[Yippy_Kiyey]

Is there a function or formula that when I insert rows and add more projects in column A of Best Section, it will be replicated in the Better and Worst sections automatically.

Excel Workbook
	A	B
4	Best
5	Project	Revenue
6	Axxx	99
7	Bxxx	77
8	Cxxx	33
9	Total	209
10
11	Better
12	Axxx	77
13	Bxxx	75
14	Cxxx	33
15	Total	185
16
17	Worst
18	Axxx	69
19	Bxxx	68
20	Cxxx	30
21	Total	167
Sheet1

Thanks

 

[kpark91]

No there isn't. doing it with formula is not possible.
it is possible with a macro tho.

 

[Yippy_Kiyey]

Can you help me with the macro, please. If I can do that, it will save a lot of time and eliminate the possibility of errors.

Thanks,

 

[kpark91]

do you want the entries to be added before or after the total?

 

[Yippy_Kiyey]

Oh thank you, it's before the totals.

Thanks again.

Rey