Paste Special?
I want to copy data from a workbook to overwrite data on another workbook but
not to overwrite the formulas. The original worksheet will have either empty cells or the value of 0 in the cells that contain the formula in the workbook it is being pasted to. I can't find an option in Paste Special. Can anyone help with this? Many thanks. |
There is not skip cells with formulas option in pastespecial.
-- Regards, Tom Ogilvy "aehan" wrote in message ... I want to copy data from a workbook to overwrite data on another workbook but not to overwrite the formulas. The original worksheet will have either empty cells or the value of 0 in the cells that contain the formula in the workbook it is being pasted to. I can't find an option in Paste Special. Can anyone help with this? Many thanks. |
Yes, I had gathered that I couldn't use Paste Special, and I wondered if
there was another way of doing it. "Tom Ogilvy" wrote: There is not skip cells with formulas option in pastespecial. -- Regards, Tom Ogilvy "aehan" wrote in message ... I want to copy data from a workbook to overwrite data on another workbook but not to overwrite the formulas. The original worksheet will have either empty cells or the value of 0 in the cells that contain the formula in the workbook it is being pasted to. I can't find an option in Paste Special. Can anyone help with this? Many thanks. |
All times are GMT +1. The time now is 02:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com