How do I stop pasted cells updating when the source cells are chan

[Guest]

I have a worksheet that contains a large array of data on one tab, organised
into a seperate column of test results for each of several characteristics.
I've created a macro for each of these characteristics that copies the
results into another tab, which in turn becomes the source data for a Report
sheet that includes a couple of charts. This allows me to run an individual
report for each of the characteristics in turn.
However, I've just created another macro that opens a new workbook, then
runs each of the individual macros in turn and copies the Report Sheet into a
new tab in the new workbook.
This works fine EXCEPT..... because the content of each new tab has been
copied from the same Report Sheet tab, each time this tab changes, they all
update and end up with identical data on them.

My question is...... If you copy data from one worksheet to another
(including Charts), then update the source, how do you stop the pasted cells
from updating automatically?

 

[Nick Hodge]

You need to record, Edit>Paste special+Values (Or values and number
formats). This will kill the formulae at the destination

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)