Hello all,
I'm in a bit of a situation and since the members of this forum have been extremely helpful, I figured this was a go to for a question such as this. I currently have a query coded that pulls data from a 3rd party. I have a from date that retrieves data until present. What I need to do next is find a way to split up this data into increments of my choosing. For example, if the data is from 1/1/2011 till present, I want to be able to have data split for 2011 on one worksheet, and data from 2012 on another. If possible, i'd like this to be as flexible so that I can do things such as analyze, say august-September of 2011 on one sheet, and the same on another for 2012.
Anything so much as a nudge in the right direction would be a big help!
Thanks
I'm in a bit of a situation and since the members of this forum have been extremely helpful, I figured this was a go to for a question such as this. I currently have a query coded that pulls data from a 3rd party. I have a from date that retrieves data until present. What I need to do next is find a way to split up this data into increments of my choosing. For example, if the data is from 1/1/2011 till present, I want to be able to have data split for 2011 on one worksheet, and data from 2012 on another. If possible, i'd like this to be as flexible so that I can do things such as analyze, say august-September of 2011 on one sheet, and the same on another for 2012.
Anything so much as a nudge in the right direction would be a big help!
Thanks