Pasting data containing a formula into a table modifies the formulas in the table

[NickonPhil]

Hi,
There may be a neat solution to this already, but pasting copied data from one worksheet (A), to the bottom of a table in another worksheet (B) changes the formula in the table in worksheet (B), to the formula within the worksheet (A). I thought (hoped), the logic would be to preserve the state of the worksheet receiving the data (B would be master, and the data arriving from worksheet A would be modified accordingly.

Is there anyway around this? I'm using Excel 2016.

Thanks
Phil

 

[sheetspread]

I thought (hoped), the logic would be to preserve the state of the worksheet receiving the data (B would be master, and the data arriving from worksheet A would be modified accordingly.

If you're pasting as formulas instead of values, some alteration will still be needed in cases like this. Bring the first cell over, align all references, then copy across/down.