Creating a spreadsheet that will filter Liju George 10.07.2006 15:14:01 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.

Re: Creating a spreadsheet that will filter "Don Guillett" <dguillett1[ at ]austin.rr.com> 10.07.2006 15:47:18 Sounds more like a project for a professional instead of a newsgroup question. -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "Liju George" <LijuGeorge[ at ]discussions.microsoft.com> wrote in message news:0E47EE17-72A4-4444-BC9D-FC5EC2EB7879[ at ]microsoft.com... [Quoted Text] > 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.

Re: Creating a spreadsheet that will filter Gord Dibben <gorddibbATshawDOTca> 10.07.2006 20:26:55 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 <LijuGeorge[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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