Forum Discussion

Kasia_MCI's avatar
Kasia_MCI
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

4 Replies

  • tauqeeracma's avatar
    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's avatar
      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's avatar
        tauqeeracma
        Iron Contributor
        Jul 09, 2019
        It would be really helpful if you share file (or sample data) . Thanks

Resources