Forum Discussion
VBA code required to save formula derived data as data.
Hi All, Bear with me here, I have an excel sheet that has formulas to help populate cells during the data entry process. The issue I have is that because the formulas are active & therefore if there...
The problem by copying the data is that your formulas will be lost, and will be necessary write all the formulas again when interacting with another amount of data.
I would suggest you to protect your data, I mean, the range where is sensitive any change.
- Thanks for the reply. I was hoping the copy & paste process could be selectively applied only to
to the cell range containing data. The rest of the workbook would still contain the formulas for future data entry assistance.
