Hi guys,
I have a roster template sheet for a full year starting cell(1,1) rota's name header, cell(1,2) date header starting from 01/04/2013 and so on.
I have a ViewStaff sheet where for convenient reasons I wish to visualise their individual rotation within the following form.
cell(14,8) is 01/04 of current year (current year is the fiscal year from 01/04/2013 to 31/03/2014)
cell(25,38) is 31/03/2014.
How to troncate the roster template into 12 rows (Apr-Mar) and 31 columns (1-31)?

Regards,
Nikenis