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

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Isis" wrote in message
...
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