i have a payroll grid. it has 3 cells with drop downs that have 39 options.
there codes for payments. i need a fourth cell to show a total dollor amount
based of the codes selected.

separate question. i have a list of cells with the same four options (Job
Types.ie service call, new connect...) i want to limit the cells mentioned
before so that payment codes that do not pertain to the job type can not be
selected.

i dont know if that makes any sence, but if you have any questions please
email me at:

http://www.contextures.com/xlDataVal13.html

Check out dependant dropdown lists, It may be what you require


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519591

thanx bro that worked out perfect....now if i can only get that first part to
work my payroll sheet will be complete......do you have any ideas on how to
get that work properly

"davesexcel" wrote:


http://www.contextures.com/xlDataVal13.html

Check out dependant dropdown lists, It may be what you require


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519591

"thanx bro that worked out perfect....now if i can only get that first
part to
work my payroll sheet will be complete......do you have any ideas on
how to
get that work properly"...

Can you specify what you require.....


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519591

I have 3 cells in one row that show codes which represent what was done at a
job. each cell has the same 39 options(the drop downs you helpped me with) i
want each code to have a dollar value. (Ie. code 201=$20.00. i want a fourth
cell in the same row to total the value of the three cells. so a guy did 3
codes 201,202,203 = $50.00. but he may only do one or two codes also.

"davesexcel" wrote:


"thanx bro that worked out perfect....now if i can only get that first
part to
work my payroll sheet will be complete......do you have any ideas on
how to
get that work properly"...

Can you specify what you require.....


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519591

Dimon1200 Wrote:

want each code to have a dollar value. (Ie. code 201=$20.00. i want a
fourth
cell in the same row to total the value of the three cells. so a guy
did 3
codes 201,202,203 = $50.00. but he may only do one or two codes also.
[/color]


I'll just use these cell references for example purposes:
ok lets see if I got this correct
If A1=201 then 20
If B1=202 then 20
if C1 = 203 then 20
but if they are all showing then 50
if only two are sowing there values then 40
if one is showing there value then 20
is this correct?


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=519591