H
hadesk
Please Help! 
I am working on configuring an expense report that all of my companie
locations can use, problem with this that for accounting purposes, eac
location has it's own handle as an extention of the general ledge
account number.
What I am trying to figure out is how to make the choice made in on
cell (through data validation, list function) change the information i
all of the cells that would correspond with that choice. Exampl
below:
Cell M5 contains a cell validated list, if corporate is chosen then
need cells A30 to change to 10000-00, A31 to change to 10001-00 and s
on, but if M5=Location 1 then I need A30 to change to 10000-01 and A3
to change to 10001-01.
Can this be done with a formula or do I need to do this within VBA?
Any help that you could offer would be greatly appreciated.
I have attached an example of the worksheet if this helps
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47681
I am working on configuring an expense report that all of my companie
locations can use, problem with this that for accounting purposes, eac
location has it's own handle as an extention of the general ledge
account number.
What I am trying to figure out is how to make the choice made in on
cell (through data validation, list function) change the information i
all of the cells that would correspond with that choice. Exampl
below:
Cell M5 contains a cell validated list, if corporate is chosen then
need cells A30 to change to 10000-00, A31 to change to 10001-00 and s
on, but if M5=Location 1 then I need A30 to change to 10000-01 and A3
to change to 10001-01.
Can this be done with a formula or do I need to do this within VBA?
Any help that you could offer would be greatly appreciated.
I have attached an example of the worksheet if this helps
Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47681