Help with conditionally unhiding columns



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

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.




Don Guillett

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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question