Excel formulas keep changing their references

[furstukin]

I have a group of formuals that find the difference of cells on multiple sheets. My problem is when I run a macro that cuts the referenced data from one sheet and pastes it on a new sheet in a new location all my formulas are changed and stop working the way I want. I have tried to lock the cell refs by doing $A$1 to all my references but it did not help. It still changed the cells and the sheets referenced. Is there any way I can avoid this short of having my macro rewrite all my formulas when it is done moving the previous day's data to a new sheet?

 

[Ruddles]

When you cut the data and paste it elsewhere, any references to the data's original location will be adjusted to point to its new location.

Try copying instead of cutting, then after you've pasted the data go back and clear it from its original position.

 

[furstukin]

When you cut the data and paste it elsewhere, any references to the data's original location will be adjusted to point to its new location.

Try copying instead of cutting, then after you've pasted the data go back and clear it from its original position.

I will give that a try thank you.

 

[furstukin]

That seemed to make it work. Extended the length of the macro slighly but no biggy. Thanks again.