The spreadsheet attached Shows a start date and end date
Along the right hand side you have WEEK COMMENCING DATES in each week number
If i put 31/03/2012 in start date and 07/04/2012 in the end date cells, i would like to hide the rest of the weeks and just have weeks 1 and 2?
This will then need to work for the rest of the sheet, i.e. If i put 07/04/2012 to 28/04/2012 i would expect only to see weeks 2 to 5.
Not the best at VBA and was wondering whether anyone can help me with this!!
Cheers
Sheet attached!
Bookmarks