Hi what i want to do is create a spreadsheet that can be adjusted by the
user. For example if we have a user in Illinois who is getting paid 30k I
want the user to choose Illinois from a drop down list and then be able to
enter in thier salary and then for the state of Illinois have a cell where it
displays the taxes that are taken out, the living allowances for that state
etc. this would be a global sheet so anyone can look at it in our company and
adjust the sheet to thier specific location. if someone can point me in the
right direction i would greatly appreciate it.

Sounds more like a project for a professional instead of a newsgroup
question.

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Liju George" <(E-Mail Removed)> wrote in message
news:0E47EE17-72A4-4444-BC9D-(E-Mail Removed)...
> Hi what i want to do is create a spreadsheet that can be adjusted by the
> user. For example if we have a user in Illinois who is getting paid 30k I
> want the user to choose Illinois from a drop down list and then be able to
> enter in thier salary and then for the state of Illinois have a cell where
> it
> displays the taxes that are taken out, the living allowances for that
> state
> etc. this would be a global sheet so anyone can look at it in our company
> and
> adjust the sheet to thier specific location. if someone can point me in
> the
> right direction i would greatly appreciate it.

See Debra Dalgleish's site for info on VLOOKUPS and also for Data Validation
Drop-down lists.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html

The DV drop-downs to pick Illinois from a list.

The VLOOKUPS to display the information you want.


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 08:14:01 -0700, Liju George
<(E-Mail Removed)> wrote:

>Hi what i want to do is create a spreadsheet that can be adjusted by the
>user. For example if we have a user in Illinois who is getting paid 30k I
>want the user to choose Illinois from a drop down list and then be able to
>enter in thier salary and then for the state of Illinois have a cell where it
>displays the taxes that are taken out, the living allowances for that state
>etc. this would be a global sheet so anyone can look at it in our company and
>adjust the sheet to thier specific location. if someone can point me in the
>right direction i would greatly appreciate it.

Gord Dibben MS Excel MVP