Hello,
I have a bunch of data that I create reports off of. This data obviously grows throughout the year. I like to keep track of it on a monthly basis. Is there anyway I can create code that will put data into the current month. example below:
in sheet 1
May=50 June=60 July=70 July= August= etc.
In sheet 2 it has all the data i'm analyzing in a data dump from a database.
now when its gets to july I want the code to realize it and choose the cell next to July and start putting data into there. then when it turns to august do the same thing etc. etc. for each month throughout the year
I have a bunch of data that I create reports off of. This data obviously grows throughout the year. I like to keep track of it on a monthly basis. Is there anyway I can create code that will put data into the current month. example below:
in sheet 1
May=50 June=60 July=70 July= August= etc.
In sheet 2 it has all the data i'm analyzing in a data dump from a database.
now when its gets to july I want the code to realize it and choose the cell next to July and start putting data into there. then when it turns to august do the same thing etc. etc. for each month throughout the year
