VLookup to Hide Columns

  • Thread starter Thread starter golf4wff
  • Start date Start date
G

golf4wff

Hi everyone -

I'm still trying to figure out how to perform this one. Within my
Timesheet tool, I use a VLookup table, on a data entry page, that
contains employee names, departments, etc...... Also on the data entry
page, are a number of columns (designated with specific housing
programs) where the employee enters their daily hours depending on
which program they work in.

The thing is that certain employees only work in certain programs where
it would be easier if the program columns that the employee does not
deal with will "hide" once the employee chooses their names from the
VLookup drop-down box. THIS IS WHAT I CAN'T FIGURE OUT HOW TO DO. I've
tried a number of different VB codes and nothing seems to work.

I was hoping someone could take a look at what I've developed and shoot
me in the right direction. ANY help would really be appreciated.

Thanks again for the help.

Frank
 
One way would be to use data validation in a cell that referred to the
employee list. Then, use a match formula to get a number from the selection
that you could then use in a select case statement to hide the rows based on
the case.....
 
Hi, Don -

Thanks for the quick response. A bit of an amateur here, but learning
as I go. Would you be willing to take a look at what I have so far and,
kind if, show me what you're referring to?

Thanks for the help,

Frank
 
Hi, Don -

Thanks again for the help. Just sent you an email with a reference to a
zipped copy. Please let me know if you receive it. If not, I can send
you an Excel full copy of the tool.

Thanks again,

Frank
 
Back
Top