Home

Coping values to cells with formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-744763%22%20slang%3D%22en-US%22%3ECoping%20values%20to%20cells%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744763%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EI%20need%20help...%20I%20would%26nbsp%3B%20like%20to%20copy%20the%20values%20from%20excel%20sheet%20to%20another%20excel%20sheet.%20The%20final%20excel%20sheet%20has%20cells%20with%20formulas%20to%20calculate%20other%20values.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-744763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744783%22%20slang%3D%22en-US%22%3ERe%3A%20Coping%20values%20to%20cells%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744783%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373338%22%20target%3D%22_blank%22%3E%40Kasia_MCI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Kasia%3C%2FP%3E%3CP%3EYou%20may%20copy%20data%20from%20one%20sheet%20and%20paste%20in%20other%20required%20sheet%20as%20'Paste%20special'.%20By%20doing%20so%20only%20values%20(data%20appearing)%20in%20cells%20in%20first%20sheet%20will%20move%20to%20second%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3ECopy%20desired%20data%26nbsp%3B%20(Clt%20%2B%20C)%20-----%26gt%3B%20Move%20to%20second%20sheet%20----%26gt%3B%20press%20right%20click%20----%26gt%3B%20press%20Pasted%20special%20values.%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744784%22%20slang%3D%22en-US%22%3ERe%3A%20Coping%20values%20to%20cells%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Tauqeer%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20replay%20but%20in%20this%20way%20I%20lost%20my%20formulas%20which%20I%20have%20in%20my%20final%20sheet.%20I%20need%20to%20copy%20those%20values%20in%20other%20sheet%20with%20cells%20that%20already%20had%20forumlas.%20I%20hope%20it%20is%20understandable.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EKasia%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-744795%22%20slang%3D%22en-US%22%3ERe%3A%20Coping%20values%20to%20cells%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-744795%22%20slang%3D%22en-US%22%3EIt%20would%20be%20really%20helpful%20if%20you%20share%20file%20(or%20sample%20data)%20.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746705%22%20slang%3D%22en-US%22%3ERe%3A%20Coping%20values%20to%20cells%20with%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746705%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20I%20was%20preparing%20the%20file%20I%20realize%20how%20to%20solve%20it.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%20a%20lot%3C%2FP%3E%3CP%3EKasia%3C%2FP%3E%3C%2FLINGO-BODY%3E
Kasia_MCI
New Contributor

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.

4 Replies

@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

 

 

 

@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

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

@tauqeeracma 

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


Thanks a lot

Kasia

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies