Hello,

I am new at vb and would like to ask some help.

I have 2 workbooks, one for general use for people to log and submit unplanned maintenance requests for equipment called MD.

My other workbook is restricted and includes a list of data (schedule) with planned maintenance requests and due dates, called LS.

Every month I have to manually submit calls in the MD for the following month and I need a macro that will repeatably submit calls in MD from the LS that are due in the selected month.

Instead of just copying and pasting the data, I would like for it to run the macro available on the MD to submit calls for all items that are due on the selected month from my list. Is there a way to automatically fill the submit form on the MD workbook from the list of data from the LS, run it, then restart the macro with the next row of data until all list is submitted? Is this possible?

Any help would be greatly appreciated.

thanks