Paste special not working as expected

[Terry Thompson]

I need to update a spreadsheet on a monthly basis. Since rows are added
often the formulas in future months tend to miss some rows.

To correct this I select the entire column from the previous month and
choose the new column to paste the formulas only. The formulas do paste but
I also get the values of each cell from the previous column which I then
have to delete.

Any thoughts are appreciated.

Terry

 

[Bob Greenblatt]

I need to update a spreadsheet on a monthly basis. Since rows are added often
the formulas in future months tend to miss some rows.

To correct this I select the entire column from the previous month and choose
the new column to paste the formulas only. The formulas do paste but I also
get the values of each cell from the previous column which I then have to
delete.

Any thoughts are appreciated.

Terry

Well, it sounds like you need a redesign of your worksheets and maybe your
work flow. I¹m not sure exactly what you are doing. A more specific example
stating what rows and or columns are copied would help. The values are the
result of the formulas evaluating. If you delete the values, you are also
deleting the formulas. If something else is happening, please explain.