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