Hi There,
I am working on a sheet where we are trying to generate revenue plan and forecast.
Requirement:
1. Generate list of dates between two dates:
1a. Exclude holidays for onsite and offshore based on the resource (Onsite/Offshore)
1b. Generate list based on one more value Plan and Forecast.
2. Along with the dates, few more columns should also be added to the generated rows from the main sheet
I am bad at using arrays and can manage only at basic macro level. The above solution will save about 3-4 four hours a day we are spending to generate spreadsheets further.
Attached is the sample spreadsheet for reference.
Regards,
Srikanth
Bookmarks