Can ChatGPT do more than just prefill data from in Excel? OH YES, YES IT CAN! It can be used to automate tasks - see video. See me ask it to write an Office JS function (not VBA!) that inserts a new row of monthly dates. It wrote the code, and it works!