Forum Discussion

Tmcgrew05's avatar
Tmcgrew05
Copper Contributor
Aug 23, 2022

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. 

No RepliesBe the first to reply

Resources