push button paste special

[pugsly8422]

I have thousands of formulas on one page, and I need to copy the results to
another page. I've been doing this one at a time, highlight the results,
ctrl+c, go to the other page, right click, paste special, paste values and
number formats.

I heard someone mention something about creating a push button, kind of like
a shortcut. Is there a way to do this to make this process any easier?

Thanks in advance!

[robert111]

switch on macro record, set to relative references, do it once. Create a circle or oval, highlight it, hover over bottom right hand corner, right click, assign macro. That is your button.

[Daniel CHEN]

Go to menu:
Tools>Customize
Select Commands tab
Select [Edit] from left Category listbox
Drag [Paste Value] from rgith commands listbox and drop it on your toolbar.


--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"pugsly8422" <[email protected]> wrote in message
news:[email protected]...
>I have thousands of formulas on one page, and I need to copy the results to
> another page. I've been doing this one at a time, highlight the results,
> ctrl+c, go to the other page, right click, paste special, paste values and
> number formats.
>
> I heard someone mention something about creating a push button, kind of
> like
> a shortcut. Is there a way to do this to make this process any easier?
>
> Thanks in advance!