View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pugsly8422
 
Posts: n/a
Default push button paste special

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!