Home

I need help copying formula between tabs in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-881825%22%20slang%3D%22en-US%22%3EI%20need%20help%20copying%20formula%20between%20tabs%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-881825%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20copied%20Columns%20from%20Webpge%20and%20pasting%20it%20on%20excel%20worksheet.%3C%2FP%3E%3CP%3EThese%20columns%20contains%20text%20and%20Numbers.%3C%2FP%3E%3CP%3EThe%20template%20was%20made%20which%20performs%20calculation%20of%20this%20Values%20and%20give%20output%20as%20Invoice.%3C%2FP%3E%3CP%3EThis%20template%20was%20working%20fine%20with%20my%20older%20PC%20which%20has%20office%202013%20installed.%3C%2FP%3E%3CP%3EI%20recently%20purchased%20Acerspin%20and%20it%20was%20loaded%20with%20Office%202016%2C%20bu%20when%20I%20am%20copying%20columns%20from%20webpage%20the%20automatic%20calculations%20are%20not%20happening%20and%20its%20giving%20%23Value%20error.'%3C%2FP%3E%3CP%3EI%20tried%20loading%20office%202013%20in%20New%20Laptop%20but%20it%20is%20again%20showing%20error%20of%20%23Value.%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-881825%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-883408%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20copying%20formula%20between%20tabs%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-883408%22%20slang%3D%22en-US%22%3EIt%20would%20help%20if%20you%20posted%20an%20example.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20data%20could%20be%20being%20pasted%20as%20text.%20You%20might%20want%20to%20try%20formatting%20it%20as%20number%2C%20then%20use%20Data%20%26gt%3B%20Text%20to%20Columns%20%26gt%3B%20Finish%20to%20coerce%20the%20format%20to%20be%20applied.%3CBR%20%2F%3E%3CBR%20%2F%3EAlternatively%2C%20try%20Data%20%26gt%3B%20Get%20%26amp%3B%20Transform%20%26gt%3B%20From%20Web%2C%20and%20import%20the%20data%20with%20Power%20Query.%20if%20you%20choose%20the%20Transform%20option%2C%20you%20can%20change%20the%20data%20type%20in%20the%20Power%20Query%20Editor.%3C%2FLINGO-BODY%3E
Highlighted
I_need_help_copying_fo
Occasional Visitor

I have copied Columns from Webpge and pasting it on excel worksheet.

These columns contains text and Numbers.

The template was made which performs calculation of this Values and give output as Invoice.

This template was working fine with my older PC which has office 2013 installed.

I recently purchased Acerspin and it was loaded with Office 2016, bu when I am copying columns from webpage the automatic calculations are not happening and its giving #Value error.'

I tried loading office 2013 in New Laptop but it is again showing error of #Value.

Can you help me with this.

1 Reply
It would help if you posted an example.

The data could be being pasted as text. You might want to try formatting it as number, then use Data > Text to Columns > Finish to coerce the format to be applied.

Alternatively, try Data > Get & Transform > From Web, and import the data with Power Query. if you choose the Transform option, you can change the data type in the Power Query Editor.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies