push button paste special

P

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!
 
R

robert111

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

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
==================================
 
Top