Hi,

We have a spreadsheet that is nearly 8 MB. We need to chart some of the
data and I thought to avoid problems with memory (old machines) that we could
use a macro to extract data to a new spreadsheet. Then I thought that doing
it that way would mean having the new spreadsheet (where the macro is running
from) and the spreadsheet that the data is being taken from open at the same
time.

What's the best way to do this or am I making a mountain out of a molehill?

TIA
--
Smudge