Forum Discussion
automating row data copying from multiple tabs into one master tab on excel 365 on Sharepoint
We use Excel 365 for work on Sharepoint to collaborate on a status sheet across projects. There are so many people updating the sheet that things are being accidentally deleted, filters are affecting...
Have you considered using Sheet Views?
https://support.microsoft.com/en-us/office/learn-more-about-sheet-views-87fb6758-edbc-4cd0-bd68-76124775e9f8#:~:text=Create%20a%20Sheet%20View%20in%20Excel%20Online%201,column%20header%20Filter%20button%2C%20click...%20.%20See%20More.
Sheet View will allow each person to customize his/her own view without changing the original workbook.
Hi Patrick2788
Thanks for the suggestion. We have been using Sheet Views for months but it is glitchy and does not always work for everyone. This is why I am trying to create a new solution.
Due to the volume of people/projects on the single tab, I am thinking the best way would be to create an individual tab per team and then automate each tab's updates (rows) to copy into a master tab where it would be one tab with all projects across the tabs. Any ideas?
Some projects will continue to get updates in the same row while new rows are added for new projects as well. Is it possible to automate copying in the existing rows of projects + get any row updates a team enters into an existing row in their individual tab?