What are your impressions of Power Automate? Is it a 'VBA Killer'?! Let me know your view in the comments!
@kabirlytics
4 ай бұрын
I think power query is vba killer to a large extend.
@TigerSpreadsheetSolutions
3 ай бұрын
Definitely in terms of collating and cleansing datasets. Power Query does that well, in a more user-friendly way, but lacks the smoothness of VBA since it works through data connections. VBA offers a lot more than dataset collation and cleansing, however. Thanks for watching and thanks for the comment!
@bradleydeans3490
3 ай бұрын
On a separate topic. Is it possible to create some buttons in the Ribbon to switch the cursor flow direction when Enter is pressed (rather than going into Options)? Perhaps using macros? Thank you for any consideration.
@TigerSpreadsheetSolutions
3 ай бұрын
It's not something I've done. I would try starting the macro recorder then changing the direction in options - to see if it registers in the macro recorder. It might be possible using an event-triggered macro with logic 'when a change is made to the worksheet, select the cell to the right / left' However, I don't recommend using event-triggered macros because they can create chaos in Excel! My thought would be to re-organise the data layout so you don't need to the the cursor flow direction. Or, simply use Excel VBA to do the data input for you?
@bradleydeans3490
3 ай бұрын
@@TigerSpreadsheetSolutions Thank you for your response. I will give the macro a try. And yes I can always reorganize the date so I only need one direction.
Пікірлер: 6