is there a way to assign hot keys or short cut keys?

I've got a f***ing stupid report that I need to compelte and it's all copying and pasting from another excel spreadsheet (that has formulae) so I want to paste special - values.

I have to dead set paste at least a few hundred times, it's f***ing pissing me off all this right click caper.

anyone know a quicker way?

aside from maco's and all that shiz - apparently this all needs to be done manually....

KARRRRNN!!!

there's gotta be a excel ninja somewhere?

this s*** is killing me, a f***ing trianed monkey should be doing this!

control c, right click paste special - values, rinse repeat x 1,000

!!!

No idea about hot keys, but this might help.

Select all data that needs to be copied, ctrl c, ctrl v, click on the paste options menu, press V. All formulas should be gone with just the values remaining, then copy from the new data without the forumals as you go.

um, this may sound like a dumb question but if it has to be done manually, what exactly are you hoping for if not a macro? A shortcut to paste special values?

this help?

last edited by whoop at 01:30:22 09/Jan/07

whoop wins - I just wanted a button that paste's special

see here - http://heardy.net/up/files/1/excel.JPG

r_amazing, I need to copy LOTS of different data and paste each line individually... I am 10000000% sure there is a better way of doing this and I'll be letting the right people know that, but being in Ireland, I can only assume they work on the 'lets do it the hardest way possible' approach.

Dead set they don't f***ing automate anything, the thing I am doing should be a f***ing REPORT out of our reporting system, but everyone is too lazy to write a spec for the dev guys to add the report, so instead we'll do it in excel and waste 2 f***ing days sitting there like a monkey cut and pasting special all day.

tools, these Irish - lucky they drink well :p

anywho, thanks whoop :)

Now we know why we got so much Alba spoot
Just buttering us up eh :0
You need Excel, ask me
I'm a f***ing genuis :p

Add this to a workbook
Assign shortcut key (of your choice) to macro

You do this by Alt + F8

Highlight the macro below
Select "options" from the dialogue box
Assign whatever shortcut key you no you don't use elsewhere

Sub PasteValues()

' Keyboard Shortcut: Ctrl+Shift+W
'
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

End Sub

Once you have the data you want on your clipboard, simply hit (in my case) Ctrl+Shift+W an it pastes whatever you have into the cells as values

PS:
you can't undo/CTRL + Z macros -
Be warned :)

I have an absolute s***load of little macros like this I should make into an addin an distribute
If you ever need a hand dude, just holler

Least I can do for so much Alba spoot!