Hello,

I have a source data sheet (Let's call this sheet1). When cells on sheet1 are populated, cells on other sheets are automatically populated via formula (Let's call one of these sheets sheet2).
(i.e. Cell A1 on sheet2 contains the formula [='sheet1'!C2] to link cells A1 on sheet2 and C2 on sheet1; when C2 on sheet1 is populated, A1 on sheet2 is populated with the data from C2)

There is a section of sheet1 that often needs to be repeated several times within sheet1. I have added a macro to insert a blank section under the previous section within sheet1. This macro also inserts an additional section on sheet2.

I would like the additional sections to be linked once inserted. Is there a way to code this?

Neither of the sections exist until I run the macro to add the additional sections. Therefore I am unable to simply insert formulas to assign cells.

I will upload the actual workbook should you need to see my dilemma first hand. Please let me know.

Thank you for any assistance or suggestions you may have!

Regards,

John