I would like to have some vba script to do the following:

Based upon a named list (employee) of which the number of items can
vary, create a new calendar year for each employee in the range.

The calendar should look like this
dateserial/isoweeknum/dayvalue/date/employee

isoweeknum is a formula I already have to calculate the weeknum of a
date
The list should start with 1-1-200n and should end with 31-12-200n
A listbox will be used to ask the user the specific year.

All calendars should be in the same columns underneath eachother (so I
have only 1 header row)

Thanks,

Mark