Paste & keep formula ?

[craigbai]

Hey guys, im trying to copy cells b15. c15 and d15

The cells above are paste links, so when i copy. It copies for example "=PartsData!$E$2" Instead of the figure thats within it. Is there a way i can copy what its displaying rather than it's formula? Using a macro button.

An how can i set the macro up to paste it on the next blank line within the range of B17, to B26?

I have successfully got it to paste them on the next blank row but only directly under B15, i wanted a gap.

Thanks. Craig

[FDibbins]

For the paste values, use Paste Values. You can set yourself up a button on the ribbon to do this for you, then all you need to do, is copy, click the cell where you want the answer, click the ribbon button

[craigbai]

Hi, im using a macro.

How do i apply it within that?

[craigbai]

Ok ive got it to copy / paste just values.

I just need to know how to make it paste them on the next empty row within the range of b17:b26 ?