any solution of my query..............
On Tue, Jan 24, 2012 at 12:47 PM, Dhartikumar Sahu <dhartiku...@gmail.com>wrote: > thanks priyanka > > but i need another way > > when i type manually on particular cell , auto pickup related that value. > (e.g. if i type *choc *and click on drop down arrow it will display the > related name of* choc.* > > > On Tue, Jan 24, 2012 at 12:40 PM, PrIyAnKa <p.dhamsa...@gmail.com> wrote: > >> Dear Dhartikumar >> >> Kindly see if below example solves your quarry >> >> *xample: Creating a drop down list with data on a different worksheet* >> >> For help with this example, see the image above. >> >> >> 1. Enter the following data into the correct cells on*Sheet 1* or a >> worksheet: >> >> *E1* - The Cookie Shop >> *D2* - Cookie Type: >> >> 2. Click on the Sheet tab for Sheet 2. >> >> 3. Enter the following data into the correct cells on *Sheet 2* or a >> worksheet: >> >> *A1* - Gingerbread >> *A2* - Lemon >> *A3* - Oatmeal Raisin >> *A4* - Chocolate Chip >> >> 4. Drag select<http://spreadsheets.about.com/od/d/g/drag_select_def.htm> >> cells >> A1 - A4 on Sheet 2. >> >> 5. Type " cookies " (no quotes) in the Name >> Box<http://spreadsheets.about.com/od/glossary/g/name_box_def.htm> and >> press the *ENTER* key on the keyboard. >> >> 6. Click on the Sheet tab for Sheet 1. >> >> 7. Click on cell E2 - the location where the results will be >> displayed. >> >> 8. Click on the *Data* tab. >> >> 9. Click on the *Data Validation* option from the >> ribbon<http://spreadsheets.about.com/od/r/g/Ribbon.htm> to >> open the menu. >> >> 10. Click on the *Data Validation* in the menu to bring up the dialog >> box. >> >> 11. Click on *Settings* tab in the dialog box. >> >> 12. From the *Allow* menu choose *List*. >> >> 13. Type " =cookies " (no quotes) on the *Source* line in the dialog >> box. >> >> 14. Click *OK* in the dialog box. >> >> 15. A down arrow should appear next to cell E2. >> >> 16. When you click on the arrow the drop down list should open to >> display the four cookie names. >> >> >> On Tue, Jan 24, 2012 at 10:46 AM, Dhartikumar Sahu <dhartiku...@gmail.com >> > wrote: >> >>> Hi Experts >>> >>> I have a data of 1000 names in Sheet2, required dropdown validation in >>> sheet1, cell A1 >>> >>> query: if i type some name on cell A1 then it display only the related >>> on that name. it's an urgent >>> >>> -- >>> >>> *Regards,* >>> >>> *Dhartikumar Sahu* >>> >>> Sr.Database Manager - Institutional Equities >>> >>> * **IDBI Capital Markets Services Ltd* >>> >>> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 >>> >>> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > -- > > *Regards,* > > *Dhartikumar Sahu* > > Sr.Database Manager - Institutional Equities > > * **IDBI Capital Markets Services Ltd* > > 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 > > Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 > > -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
