Re: Automatically copy a data result of a cell from a filtered spreadsheet into another table

Hi Crimzo , you can automize your Excel Online consolidated calculations within Office Script. This is the successor of Excel VBA, but it works with online scripting, not VBA. Additionally you can automatize your several filter stuff within Workflows and Power Automate! This saves you a bunch of wasted time I can imagine 🙂 Here is a good intro from Daniel Laskewitz, in english, very easy to understand: 

1) https://www.youtube.com/watch?v=abGwAQt-4Aw

part 2) https://www.youtube.com/watch?v=jBO1nGLeTQs 

Have fun with your new online scripts then and give a LIKE, if it helps. Yours, Eva.