I have a spreadsheet like this:
-------------------------Dept 1----Dept 2----Dept 3----Dept 4----etc (Cells
C5:R5)
Expense Code A
Expense Code B
Expense Code C
Expense Code D
Expense Code E
etc
Drop down validation box in Cell B4.
When I choose a Dept from the dropdown box I want every other Dept Column to
be hidden.
My knowledge of VB doesn't extend beyond being able to paste into a module &
some basic editing so any help is appreciated on this !
Phil
Bookmarks