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 filtered criteria? i.e. copy the corrected mean for Unit 1 at 1m, then Unit 1 at 2m and so on. 

 

I have an example attached where I want to copy the corrected mean for each 1m interval per unit in table A to table B. I have filled the results for data 1 into table B. 

 

Currently I am copying and pasting with crtl+V and changing the filter each time. From a previous comment and help from this forum that has allowed me to do this for the Count and Sum values, but I am not sure if I can do this for longer formulas. Is there a way to tell excel to copy the result in a given cell that meets each of the filtered criteria automatically? Any help will be much appreciated!

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.

1 Reply

  • 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