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.
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?
@@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.
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!
What are your impressions of Power Automate? Is it a 'VBA Killer'?! Let me know your view in the comments!
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.
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?
@@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.
I think power query is vba killer to a large extend.
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!