I have a multi tab workbook that shares data between two tabs. The tabs are titled "Budget" (which is the master sheet) and "Projections" (which is the target sheet that copies from the master in several columns but also has formulas in other columns that make calculations from the data in the columns containing data being pulled from the master sheet).

Sometimes single, or multiple lines (all in one block...meaning they are consecutive rows), need to be added or deleted in various spots on the "Budget" tab. I am looking for code that will facilitate the automatic updating of the "Projections" tab by adding or deleting the lines in the same location(s) as the lines added or deleted on the "Budget" tab. In addition, the formulas across the entire row need to copy down on the "Projections" tab when lines are added.

I appreciate any help other members can provide.

Regards,
rlr