How to automatically copy data from one Excel tab to another tab (same worksheet) in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-2780922%22%20slang%3D%22en-US%22%3EHow%20to%20automatically%20copy%20data%20from%20one%20Excel%20tab%20to%20another%20tab%20(same%20worksheet)%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2780922%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20uploaded%20an%20Excel%20sheet%20to%20Sharepoint%20and%20I'm%20trying%20to%20find%20a%20formula%20to%20automatically%20copy%20data%20from%20one%20Excel%20tab%20(tab%202)%20to%20another%20Excel%20tab%20(tab%203)%20in%20Sharepoint%20but%20it%20doesn't%20work.%20I%20am%20finding%20that%20the%20formula's%20that%20usually%20work%20in%20Microsoft%20Excel%20don't%20work%20as%20soon%20as%20it's%20uploaded%20to%20Sharepoint.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2780922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806267%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20automatically%20copy%20data%20from%20one%20Excel%20tab%20to%20another%20tab%20(same%20worksheet)%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806267%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1165401%22%20target%3D%22_blank%22%3E%40Serenalip%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsocial.technet.microsoft.com%2FForums%2Fen-US%2F5cb1bcf9-4838-4127-b86a-297f2cf7bbd0%2Fsharepoint-online-amp-excel-formula-reference%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESharePoint%20Online%20%26amp%3B%20Excel%20Formula%20Reference%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eonce%20you%20upload%20it%20in%20sharepoint%20the%20formula%20references%20change%20to%20a%20url.%20see%20link%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi there.

 

I have uploaded an Excel sheet to Sharepoint and I'm trying to find a formula to automatically copy data from one Excel tab (tab 2) to another Excel tab (tab 3) in Sharepoint but it doesn't work. I am finding that the formula's that usually work in Microsoft Excel don't work as soon as it's uploaded to Sharepoint. Any ideas?

1 Reply