Coping values to cells with formulas

[Kasia_MCI]

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.

[#2]

@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

[#3]

@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

[#4]

It would be really helpful if you share file (or sample data) . Thanks

[#5]

@tauqeeracma 

While I was preparing the file I realize how to solve it.

Thanks a lot

Kasia