1st part:
If the macros refer to the other sheets at all, you won't be able to do it.
But...
In case there's any formulas on your Results sheets, select all, select
copy, and then right-click, Paste Special, select values.
Now you could simply select all the other sheets (You can use Shift to
select an array of sheets) and delete them. Then email the single sheet.

2nd part: What rules guide what you can change? Can you just delete numbers?
Can I change them all?? Need more info

3rd part: To set all numbers equal parts of 100%, and if numbers are in
A2:A100
=100/COUNTA(A$2:A$100)
And place this formula into the B column next to your numbers.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hoole" wrote:


hi everyone .I am new to excel so please be gentle with me.
2 things.
I have a spreadsheet I that I " inherited " it is quite large and has
a number of sheets which produce results which are entered into the
first page. Is there a way of seperating the first page ( results page
) from the rest when all data is entered so I can email it easier, the
result page still has to have macros enabled and have all its
finctionallity .
I have one column of results ( R ) which might be
-21,-6,-2,13,15,18,19,34,46,68,89,104, etc and a variable number of
rows from 3 to 40 ,I need to make the total of this column =100% and
then each number = an equivalant proportion of the 100% how can I do
that
thanks in advance
hoole




--
hoole