Pasting between tables: Don't change existing formulas in destination table

Hello there.

When I click "make rows" the OUTPUT table is populated. The problem is, when I go and click the button again for "Dyllan White" the formula that I have in the PURPLE cell pastes correctly into the OUTPUT table - its just that all the other formulas in the Purple column (for Mary J) then also changes to match what was just pasted.

Question 1: Is there anyway to get around this?

Question 2: If there were a comment on "NDO" in the input table, how can I modify my code such that it also gets pasted into the OUTPUT table?

Excel Workbook: Row Generator.xlsm

screenshot.png

Please Login or Register  to view this content.