Learning Excel Macro now or wait for more AI?

[anaconda777]

Hello members!

I have some aspects of my job that could be done more efficiently with Excel macros.

To put it simply, I want to start with a spreadsheet with a significant amount of information, and turn it into a particular report. Steps would include: adjusting rows and columns, transferring data to particular cells, removing particular information, populating in formulas, color formatting, etc.

I am under the assumption I could tell an AI to do this, using regular human language, in the not so distant future.

Is it worth learning the Macros codes now from scratch? It can feel daunting at times.

Thank you.

 

[Joe4]

The warning at the top of this forum may give you a hint:

There has been a LOT of bad info coming from AI right now, as it pertains to Excel VBA code. Maybe at some point in the future, it will be more reliable. How soon? I have no idea.

I would recommend learning Excel Macros. It is a good skill to have. Just start small, and work your way up.
The Macro Recorder is a great tool for beginners. You can record yourself performing steps manually in Excel, then stop the Macro Recorder, and see what the code behind it looks like.
I would also recommend either getting a good introductory VBA book (the MrExcel bookstore has some of those), or finding some good on-line tutorials.
And you can always post here with any specific questions!

 

[anaconda777]

Thank you. I will dive in and see what happens.