I am aware that a Macro will be the best way, and I have tried recording this myself but as the length of the list varies and so does the length of each month I cannot get this to work correctly for me. It needs to be something where I can fill out the list of asset ID's for the month, enter the date for the first day of the month, hit a button and voila!