LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default CREATE DATA FORM FOR DEPENDANT DROPDOWN LIST IN EXCEL

I need to enter data in rows under around 5 column headings
Column A has a dropdown list covering around 6 items .- Each of these 6
items have 2 to 3 dependent items coming under and then these dependent items
under column B have around 3 to 4 dependent items under column C - etc etc
Can someone help me to create a dataform that would only allow to pick data
that is dependent upon previous left column .and thus enter the data in an
empty row.
Subsequently I have a pivot which picks up all this entered data -i dont
need help on that - but only on the data entry form
Thanks

 
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
select dropdown list dependant on value of a given cell abo Excel Discussion (Misc queries) 2 July 2nd 07 04:16 PM
create a list dependant on info in a column Steve Excel Worksheet Functions 3 June 18th 07 05:11 PM
Excel 2003 - Customise a Data Form for dropdown lists JohnLBS Excel Discussion (Misc queries) 1 May 3rd 07 11:55 AM
How do I create a dropdown list using data from a different workbo VFPguruExcelNovice Excel Worksheet Functions 4 March 6th 06 07:50 PM
Use dropdown list from Form Gerrym Excel Discussion (Misc queries) 1 January 4th 05 01:24 PM


All times are GMT +1. The time now is 09:07 PM.

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

About Us

"It's about Microsoft Excel"