Drop Down Boxes or Macros?
 

Hello,
I needed some help with the following:

I have a drop down box of departments (finance, accounting, etc.) Basically,
I would like it so that a user picks the department, then he fills out some
of the expenses. Then he can choose another department with the same dorp
down box and fill out that department's expenses. However, the catch is I
would like the information that was input for the first department selected
to remain. Are there any ideas?

Drop Down Boxes or Macros?
 

I would use dropdown boxes (DataValidation) in separate cells. If you
create a list of the departments, you can point both DVs to that list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"A.S." wrote in message
...
Hello,
I needed some help with the following:

I have a drop down box of departments (finance, accounting, etc.)
Basically,
I would like it so that a user picks the department, then he fills out
some
of the expenses. Then he can choose another department with the same dorp
down box and fill out that department's expenses. However, the catch is I
would like the information that was input for the first department
selected
to remain. Are there any ideas?

Drop Down Boxes or Macros?
 

I don't think that will work: To illustrate:

Drop - Down Box - Finance, Accouting, etc. (5 others)

Expenses:
Relocation, Recruiting, etc. (list has 30 items)
Now, I am forecasting so they will put these expenses for 12 months for each
expense for each department. Therefore, if I create multiple drop down lists,
I still have the same problem, because it is the same expense types for each,
however, the amounts will all vary depending on department. I can not create
multiple lists because it is too much stuff. Any ideas on how I can do this?
Thanks.
"Bob Phillips" wrote:

I would use dropdown boxes (DataValidation) in separate cells. If you
create a list of the departments, you can point both DVs to that list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"A.S." wrote in message
...
Hello,
I needed some help with the following:

I have a drop down box of departments (finance, accounting, etc.)
Basically,
I would like it so that a user picks the department, then he fills out
some
of the expenses. Then he can choose another department with the same dorp
down box and fill out that department's expenses. However, the catch is I
would like the information that was input for the first department
selected
to remain. Are there any ideas?

Drop Down Boxes or Macros?
 

I don't understand why that wouldn't work.

Maybe you mean that when you select a department, the Expense type dropdown
should be specific to that department. If so, see
http://www.contextures.com/xlDataVal13.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"A.S." wrote in message
...
I don't think that will work: To illustrate:

Drop - Down Box - Finance, Accouting, etc. (5 others)

Expenses:
Relocation, Recruiting, etc. (list has 30 items)
Now, I am forecasting so they will put these expenses for 12 months for
each
expense for each department. Therefore, if I create multiple drop down
lists,
I still have the same problem, because it is the same expense types for
each,
however, the amounts will all vary depending on department. I can not
create
multiple lists because it is too much stuff. Any ideas on how I can do
this?
Thanks.
"Bob Phillips" wrote:

I would use dropdown boxes (DataValidation) in separate cells. If you
create a list of the departments, you can point both DVs to that list.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"A.S." wrote in message
...
Hello,
I needed some help with the following:

I have a drop down box of departments (finance, accounting, etc.)
Basically,
I would like it so that a user picks the department, then he fills out
some
of the expenses. Then he can choose another department with the same
dorp
down box and fill out that department's expenses. However, the catch
is I
would like the information that was input for the first department
selected
to remain. Are there any ideas?