Forum Discussion

Crimzo's avatar
Crimzo
Copper Contributor
Nov 05, 2020
Solved

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

Hi everyone, I was wondering if it is possible to automatically copy a result in a given cell that is calculated from a filtered spreadsheet dataset, and paste it into another table that meets the fi...
excel
Formulas and Functions
Macros and VBA
  • Eva Vogel's avatar
    Eva Vogel
    Nov 05, 2020

    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.

Eva Vogel's avatar
Eva Vogel
Iron Contributor
Nov 05, 2020

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.

Resources