Forum Discussion

Copper Contributor

Jul 09, 2019

Coping values to cells with formulas

Hello, I need help... I would like to copy the values from excel sheet to another excel sheet. The final excel sheet has cells with formulas to calculate other values. Thanks in advance.

excel

Formulas and Functions

tauqeeracma

Iron Contributor

Jul 09, 2019

Kasia_MCI

Hi Kasia

You may copy data from one sheet and paste in other required sheet as 'Paste special'. By doing so only values (data appearing) in cells in first sheet will move to second sheet.

Copy desired data (Clt + C) -----> Move to second sheet ----> press right click ----> press Pasted special values.

Thanks,

Tauqeer

Kasia_MCI
Copper Contributor
Jul 09, 2019
tauqeeracma
Hi Tauqeer,

Thanks for replay but in this way I lost my formulas which I have in my final sheet. I need to copy those values in other sheet with cells that already had forumlas. I hope it is understandable.

Thanks,
Kasia
- tauqeeracma
  Iron Contributor
  Jul 09, 2019
  It would be really helpful if you share file (or sample data) . Thanks
  - Kasia_MCI
    Copper Contributor
    Jul 10, 2019
    tauqeeracma
    While I was preparing the file I realize how to solve it.
    
    Thanks a lot
    Kasia