basically here is what I have. on sheet a I have a drop down that is
controlled by a valadation list. I want the entries on sheet "b" to be
controlled by what is selected in sheet "A" basically I have employee names
on left going down column "A" and going across row "A" is where the headers
are. I want the information to be changed on the headers based on what i
select.

Darrell_Sarrasin wrote:
Not sure how I am doing this one yet.... My code last I tried it made the
file too large. I have to keep my file size small.

not sure if a macro or the vloopup is the way to go.

Where is the source of the names to be filled in?

[quoted text clipped - 10 lines]
with employee names. I need a macro to allow me to select the department and
auto fill it with employee's based on the department.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/201005/1