Forum Discussion

Copper Contributor

Sep 24, 2021

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

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 doe...

Excel for web

Formulas and Functions

Yea_So

Bronze Contributor

Oct 02, 2021

Serenalip

https://social.technet.microsoft.com/Forums/en-US/5cb1bcf9-4838-4127-b86a-297f2cf7bbd0/sharepoint-online-amp-excel-formula-reference

once you upload it in sharepoint the formula references change to a url. see link