LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sa sa is offline
external usenet poster
 
Posts: 7
Default choosing off various lists

Can anyone point me in the right direction to get some help?

I have a spreadsheet that is used to track financcial data. Currenlty you
type in the type of expense in two columns (eg: "gasoline" and "car 1" or
"phone" and "mobile #1". I have catagorised every type of expense broken down
into groups using a three part number (eg 11.14.02). Can I put a
formula/function/something in that allows me to choose off a small list in
column 1 (eg. showing "11 - Car expenses" and putting "11" in the box) which
then gives a different clist to choose off in colujmn two depending on what I
chose in column 1 (eg. showing "14 - gasoline" and putting 14 in the cell)
and the same for the third column? So what happens is you get a different
drop down list (with about 6 choices each) depending on what you chose in the
previous column.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Lists... Corey Excel Discussion (Misc queries) 0 July 5th 06 08:39 PM
Lists... Corey Excel Discussion (Misc queries) 0 July 5th 06 08:34 PM
VLOOKUP and Multi Lists dpatte601 New Users to Excel 6 May 17th 06 10:40 AM
Excel - need a function to compare lists JerryMatson Excel Worksheet Functions 1 November 24th 05 04:09 PM


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"