Thread: array formula pasting

so - here it is
I made use of arrays to collect data and did all the work on one sheet...
the problem is that I really would like to have this information on separate sheets.
so that I don't have to retype the formulas and cut and paste and edit.....

how can i get the results of an array from one sheet to another....
I am hopeful this is easy and I am just dumb....


thanks in advance....

Originally Posted by DonkeyOte

Do you mean

=Sheet1!A1

where Sheet1!A1 holds the original Array formula ?

-
yup -
that would be it - - thanks I had to drag the formula down the column and that is what i did not understand before.