Current location - Training Enrollment Network - Books and materials - Excel replaces values in formulas in batches.
Excel replaces values in formulas in batches.
I am used to copying the data I want to use into the same excel. For example, the first worksheet of an excel file is used as a monthly report, and the second table is used as a summary of last month. Just copy the data every month, without changing the formula. If you want to save data every month, remember to save it as.

If you are too lazy to make a new form now, you can first copy the monthly report of 201101to another folder, and then paste the monthly data into E:\ monthly production report \[20 165438].