Another user helped me with this code a few months ago however I now have a problem with it... please see the example sheet attached.
On the a-z sheets the 2nd column of dates does not work....
If you fill in date and the details On the shorts and overs pages and press ctrl x to run the vba macro it only enters the data on the first columns (1-Apr to 23-Sep) of the a-z sheets.. the dates 30-Sep to 24-Mar do not work.
I hope this makes sense and any help to solve the problem will be greatly appreciated.
Thanks
Bookmarks