HI I have below code. I use to search for all rows from January and then copy to another sheet.
I have this kind of macro for all months.
I need to be able to change the year in the code from example 2013 and instead to 2014.
I have before dont this by making a reference to a cell and put this reference in the code.
In this case i cant make it work.
I want to make a refernce to example cell AW1 and then type in cell 2013. Then i can change the year in the cell.
I have tried this but it dont work.
Please have a look and see how 2013 in the code can be changed to 2014 example.
Thanks in advance.
Abjac
Here is my code as it looks now.
Bookmarks