copying formula into another sheet as number

[mutu]

Hi all,

i have some numbers on columns A,b,c..... and i have a formula based on those number on column I
Formula is based on Random numbers ( = Rand() ...)
so as you know some number changes when i add other rows...
basicly what i want to do is, copying numbers on another sheet as number...
but the numbers on sheet2 will not change when i add something..

Thanks in Advance

MuTu

[starguy]

Copy the range of numbers, go to other sheet, right click > Paste special > check Values and click Ok
It will paste formula as numbers and will not change any more.

(you can also record a macro for this if you need to do it again and again)

[mutu]

hehehe i am so stupid.... thanks a lot...
how do i record macro for that?
i need to do this at least 100 times

[starguy]

Select the range of cells to be copied.
Go to Tools > Macro > Record Macro (give name of the macro and assign any shortcut key to it. like Ctrl+q etc) press Ok
(it will open a tiny toolbar)
Press Ctrl+C to copy the already selected range, go to other sheet and Paste special as values.
Come back to the original sheet and press Stop macro button on the tiny toolbar.

Now you can use that shortcut key to run the macro or assign that macro to a button.
To make a button go to View > Toolbars > Forms and click on the Button tab and draw it on your sheet then right click on that button and Assign macro to it.

[mutu]

thanks a lot starguy...

[starguy]

You're welcome.