multiple selection copy & paste across multi-worksheets

A

aw

Dear sir / Madam,

I would like to copy multiple selection range but within 1 sheet (long &
complex formula) into another file (this time need to convert to ‘value’) but
the other cells near the above range should remain unchanged.

Can EXCEL without using VB can handle this? If not, appreciate so much if
you can give me some hints about the VB code.

Actually I have multi worksheets and need to copy & paste in this way.

Tx & rgds
 
Top