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.
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 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.
While I was preparing the file I realize how to solve it.
Thanks a lot