Prev: .value
Next: Select from a list of workbooks that are open
From: Darrell_Sarrasin via OfficeKB.com on 14 May 2010 16:08
here is what I am looking at.

I have two seperate worksheets. on sheet A I have a drop down naming
departments. on sheet b I have an area that basicallly from a2-a50 fills in
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.aspx/excel-programming/201005/1

From: Gord Dibben on 14 May 2010 17:02
Where is the source of the names to be filled in?

Where are they to filled in?

Have you tried VLOOKUP formulas?


Gord Dibben MS Excel MVP

On Fri, 14 May 2010 20:08:01 GMT, "Darrell_Sarrasin via OfficeKB.com"
<u33691(a)uwe> wrote:

>here is what I am looking at.
>
>I have two seperate worksheets. on sheet A I have a drop down naming
>departments. on sheet b I have an area that basicallly from a2-a50 fills in
>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.

From: Darrell_Sarrasin via OfficeKB.com on 14 May 2010 21:59
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.

Gord Dibben wrote:
>Where is the source of the names to be filled in?
>
>Where are they to filled in?
>
>Have you tried VLOOKUP formulas?
>
>Gord Dibben MS Excel MVP
>
>>here is what I am looking at.
>>
>>I have two seperate worksheets. on sheet A I have a drop down naming
>>departments. on sheet b I have an area that basicallly from a2-a50 fills in
>>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 http://www.officekb.com

From: Darrell_Sarrasin via OfficeKB.com on 17 May 2010 08:34
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.aspx/excel-programming/201005/1

 | 
Pages: 1
Prev: .value
Next: Select from a list of workbooks that are open