Below is a rough breakout of what I am trying to accomplish. Say I
have a group of costs "Total Land Acquisition Costs" and I need to add
3 more lines between "Due Dilligence, Closing, Title" and the "Total
Land Acquisition Costs." I need the macro to select the bottom of the
group of costs for "Land Acquisition Costs" which is row #5 right now
and insert an entire line there. Each group of costs is separated by
its "Total amount," thus signigaling a break of costs. Then it needs
to copy the row above and paste that formating and cell formulas into
the newly inserted row. Each time you press the macro, it needs to
know the bottom of those costs, rather then select row #5, but rather
row #6 after pressing the macro for the second time and so forth and
always copy the row above its formating and formulas without adding
lines in a separate budget item like "Land Development Costs" or
always selecting a distinct row number. After that is complete, this
row then needs to filter throughout the model. If you can figure this
out first, then I can visualize the second step of how it needs to
filter out.

row

1 Budget Costs
2
3 Land Acquisition $50000
4 Due Diligence, Closing, Title $5000
5 --
6 Total Land Acquisition Costs $55000
7
8 Land Permits and Fees $5000
9 Land Dev- Internal $700
10 Land Architect & Engineer $3000
11 Land Site Indirects $0
12 Land Holding costs $0
13 Land Processing & Entitlement $0
14 Land Acquisition - Pili Mai Monthly
$0
15 --
16 Total Land Development Costs $8700