SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1856280%22%20slang%3D%22de-DE%22%3ESubject%3A%20Automatically%20copy%20a%20data%20result%20of%20a%20cell%20from%20a%20filtered%20spreadsheet%20into%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856280%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F854257%22%20target%3D%22_blank%22%3E%40Crimzo%3C%2FA%3E%20%2C%20you%20can%20automize%20your%20Excel%20Online%20consolidated%20calculations%20within%20Office%20Script.%20This%20is%20the%20successor%20of%20Excel%20VBA%2C%20but%20it%20works%20with%20online%20scripting%2C%20not%20VBA.%20Additionally%20you%20can%20automatize%20your%20several%20filter%20stuff%20within%20Workflows%20and%20Power%20Automate!%20This%20saves%20you%20a%20bunch%20of%20wasted%20time%20I%20can%20imagine%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%20Here%20is%20a%20good%20intro%20from%20Daniel%20Laskewitz%2C%20in%20english%2C%20very%20easy%20to%20understand%3A%3C%2FP%3E%3CP%3E1)%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DabGwAQt-4Aw%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DabGwAQt-4Aw%3C%2FA%3E%3C%2FP%3E%3CP%3Epart%202)%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjBO1nGLeTQs%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjBO1nGLeTQs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20fun%20with%20your%20new%20online%20scripts%20then%20and%20give%20a%20LIKE%2C%20if%20it%20helps.%20Yours%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856223%22%20slang%3D%22en-US%22%3EAutomatically%20copy%20a%20data%20result%20of%20a%20cell%20from%20a%20filtered%20spreadsheet%20into%20another%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856223%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%20I%20was%20wondering%20if%20it%20is%20possible%20to%20automatically%20copy%20a%20result%20in%20a%20given%20cell%20that%20is%20calculated%20from%20a%20filtered%20spreadsheet%20dataset%2C%20and%20paste%20it%20into%20another%20table%20that%20meets%20the%20filtered%20criteria%3F%20i.e.%20copy%20the%20corrected%20mean%20for%20Unit%201%20at%201m%2C%20then%20Unit%201%20at%202m%20and%20so%20on.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20example%20attached%20where%20I%20want%20to%20copy%20the%20corrected%20mean%20for%20each%201m%20interval%20per%20unit%20in%20table%20A%20to%20table%20B.%20I%20have%20filled%20the%20results%20for%20data%201%20into%20table%20B.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECurrently%20I%20am%20copying%20and%20pasting%20with%20crtl%2BV%20and%20changing%20the%20filter%20each%20time.%20From%20a%20previous%20comment%20and%20help%20from%20this%20forum%20that%20has%20allowed%20me%20to%20do%20this%20for%20the%20Count%20and%20Sum%20values%2C%20but%20I%20am%20not%20sure%20if%20I%20can%20do%20this%20for%20longer%20formulas.%20Is%20there%20a%20way%20to%20tell%20excel%20to%20copy%20the%20result%20in%20a%20given%20cell%20that%20meets%20each%20of%20the%20filtered%20criteria%20automatically%3F%20Any%20help%20will%20be%20much%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1856223%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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!

1 Reply
best response confirmed by Crimzo (Occasional Contributor)
Solution

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.

In the second video of this week, you will learn more about Power Automate & Excel scripts! Excel scripts are a way to automate specific actions. You can cre...
In this week's video, you will learn about Power Automate & Excel scripts! Excel scripts are a way to automate specific actions. You can create an Excel scri...