Copying Values but keeping rows that have formulas in them

I have a spreadsheet with a lot of financial information going down a column (about 500 rows down). Most of the cells are just typed in, but certain rows have sum formulas in them. Is it possible to copy values from another workbook, paste the values in, but somehow keep the formulas that are running through? Thanks.

Hi Amartino,

Below is some code that copies data from another workbook to a set of cells while retaining the formulas those cells may include. I have attached 2 workbooks, "PasteBook" and "CopyBook" as an example. To run the code, save the attached workbooks to the same folder, open "PasteBook", then hit "<CTRL> z" and it will copy over the cells in Column C while also retaining the formulas in that column. There are formulas in cells "C8", "C16" and "C22".

Thanks,

Daniel

Please Login or Register  to view this content.