Paste Special

[jitendra]

Hi all,
Can anyone help me how to solve the below problem.

Actually I have some data in a report which in which some data are according to formula and some information which is linked with another sheet and I want to make those cells Paste special values and want to delete the raw data sheet.

 

[buxtongt]

Are you trying to do this in a macro? Doing it manually just involves right clicking, selecting "Paste Special" and selecting "values", or right clicking and selecting the values icon under paste special (in excel 2010). Hope this helps.

 

[jitendra]

Are you trying to do this in a macro? Doing it manually just involves right clicking, selecting "Paste Special" and selecting "values", or right clicking and selecting the values icon under paste special (in excel 2010). Hope this helps.

Thanks for reply but i want make paste special only those cells which are linked with another Sheet. so is there any macro which can solve my problem.