Office Scripts can be created with a few clicks to help with repetitive actions in Excel. Add Power Automate into the mix and you can automate almost anything in Excel. Learn More: aka.ms/globalexcelsummit/offi...
Пікірлер: 13
@jonsteen10 ай бұрын
This is exactly what I needed. I'll be implementing it tomorrow. Thanks.
@AprilDunnam10 ай бұрын
Awesome!
@gastondemundo98227 ай бұрын
@@AprilDunnam with version of office have the Automate tab?
@abhijeetrajput64174 ай бұрын
Super awesome.
@AprilDunnam4 ай бұрын
Thank you! Cheers!
@DoubleBarrelRiot8 күн бұрын
Does this only work for the lines that the recording predetermined? Or is it able to sense if there are hundreds of entries in Column B and C and add the formula in as far down as the data goes?
@journeyonthewheels2317 Жыл бұрын
Is this automate option available in office 2019?
@Shankyrana228 ай бұрын
Wonderful 👍
@AprilDunnam7 ай бұрын
Thank you! Cheers!
@Lahmeinthehouse8 ай бұрын
What if you have one excel sheet that you want to use for lookups, based on another file in power automate ?
@uartimАй бұрын
You can write a function in your script use 'Run the script through Power Automate' to add your input, which maybe your result from another excel file.
@reginaldphillips76155 ай бұрын
You’ve been to do this with VBA for decades
@AprilDunnam5 ай бұрын
Ah, VBA, the timeless classic.... It's like the grandpa of low code programming languages