Hi new to this and would like to know if something is possible. Sorry if I get the terminology wrong
I have a workbook with multiple sheets it calculates how many days by a resource type and then costs it, each worksheet has a different team resource requirement.
On the first sheet I have information about the request including the start and completion date from which I also worked out how many months the project will run for
I want on each worksheet to create a table that sets out the months that will be from the start date to the completion date so if the start dates is are 01/01/2015 to 01/06/2015 I want a table with Jan Feb Mar Apr May Jun so I can then apply how much resource per moth will be required
I have some of whats needed using match but I can't get the wild card to match Jan to 01/01/2015 and also to set the size of the table
Any thoughts on this please.
Bookmarks