Consistently copying formulas between sheets or between files

[mpierce84]

I use Excel 2008 for Mac.

I'm looking for a consistent way to automatically copy formulas between sheets in a workbook, and between separate files. I know about Paste Special but using this feature adds a lot of time to my day. I would like this to work with just control-C.

It seems to work about 80% of the time but then "randomly" at other times it just pastes the values. This is really annoying. Anyone have any insight?

[pr4t3ek]

would you like it to paste values only or everything which is copied?

[mpierce84]

If the cell contains only a value, I want to transfer the value. If the cell contains a formula I want to copy the formula. I'd like this to work even if there's a mixture of the two.

This seems to be the default most of the time. I just can't figure out why it sometimes pastes only values.