Hi,

I have created a few macros in an Excel spreadsheet, but I had to click "RUN" Macro every time in order for the data to update. If possible, can you please show me if there is a way for me to update the data and it runs automatically.

Thanks for any helps.

I haven't played with Excel in quite sometime, but I believe that when you are setting up the macro you tell Excel whether the macro is an on demand macro or an automatic macro that opes and runs when the spreadsheet is opened.

I've got to scoot out and take my granddaughter to lunch but after that, I'll take a look at my version of excel and see what's going on.