I have a sheet that produces a list that is then featured on a load of
drop down's on another sheet - an available staff list.

On the sheet with the drop downs (in rows) I tabulate each staff members
hours in a column to the right.

Across the top of the columns I have each staff members name - and I
calculate their hours with formulae like this;

IF($B16=L$3,$AA16*$AB16) - where L$3 contains their name as a column
heading

I have 6 columns unhidden with fixed names and I have hidden 6 others for
use when their are more staff available.

I now want to automate the process of filling in the column headings -
this will also mean hidding, unhidding columns based on how many staff
are available and also filling in the names of available staff across the
unhidden columns and setting the headings on all hidden columns to
something like 'hidden' so they don't pick up any values.

So on the page with the names I have already managed to automate the
staff list by having a complete list and then requiring the user to place
a '1' in the cell next to each name that is available and finally
pressing a list button which produces the source for my drop downs

I am presuming I will use this same list to copy the names to the column
headings on the second sheet but I will also need to unhide the required
number of columns.

I know the code to hide or unhide a column but just need a little help
with the counting etc.

Any help appreciated.

Thanks