The attached is a sample of the data I am working with. The actual workbook contains 7 sheets with a total of <500 different items.
The worksheet is used to formulate the forecast for our items.
Each month I need to add/insert a new row after each item so each month an additional new row is inserted manually.
Can this process be automated with a macro.
I tried the attachment on http://ozgrid.com/forum/viewthread.php?tid=3561 but that did not work for this example.
I appreciate your time and attention.
Bryan