VBA code to report from worksheets to a cover sheet

Hi all

I have attached a spreadsheet that I am developing to help me forecast finish dates based on resources (men) I have available and use.

The resources are assigned in the right hand table with a drop-down list.

The grey cells are entered manually and the green ones update automatically (this all works as intended), but as per my two sample worksheets, I would like the job number (cell B4) to report to the front worksheet, along with the resources allocated (cells B9 to B16) to the appropriate week. I would like this to occur with any worksheets I have created in workbook.

On the worksheet 232325, there are 2 resources booked (cell B9) for 2 weeks (cell E9), so the front sheet will insert 2 in each of the days for the first two weeks (week starting 4/7/16), then 3 men for one week (week starting 18/7/16) etc.

I expect that at any time there may be between 10 and 20 worksheets at any time.

Hopefully my sample explains it well enough, if not please let me know and I will try and explain further.

Any help greatly appreciated.

Thanks, Robbo

Hi all

Just wondering if anyone has been able to have a look at this for me.

If anything needs clarification, please let me know.

Thanks, Robbo

Thanks dflac, much appreciated.

I was hoping that each job number would only occupy one line, as per the attached sample (manually updated to show what I'm hoping for).

If we could tweak that part, it would be exactly what I'm looking for.

Thanks again, Robbo

Brilliant, thanks.

Robbo

Nailed it for me, exactly what I was after.

Thanks dflak, it's much appreciated.

Robbo