Forum Discussion
VBA coding
Hello,
I have tried to play with vba coding and have been able to do some basics. However, I am still new to vba and am wanting codes that will "save as (next month)" based on either a tab or cell value, code to change the date on tab #1 then update the queries to look at the 'current' month. What I have is a spreadsheet that has a summary page and has tabs numbered 1-31. Each one of those tabs represents the day of the month. I have a query set up to pull data from our SQL and formulas to calculate that data into each cell. Of course I have a few bugs I'm still trying to work out. For example, when the new month starts pulling in, my previous months data is gone and I have to go in and tweak a few setting to pull in "previous" month. Anyone have any ideas that could help, I would greatly appreciate it.