Name: Aindril De (Andy) Tip: Create Validation List from Data in Different Sheet
A lot of times, when creating a validation list, we might want to get the data from another sheet in the workbook. But by default, Excel does not allow the validation data to be captured from another worksheet. To work around this limitation, we have to do the following steps: 1) Select the range in another sheet that we want to appear in our validation list. 2) Define a name for the selected range. For e.g. Cont 3) Select the area in the other worksheet where you want the validation list to appear. 4) Choose the validation type as list. 5) In the source, if you try to switch to the other sheet, you will notice Excel is not allowing to do so. 6) Type =<Range Name> i.e the range name that we have just defined. <NOTE: donot write the name as it is without the = symbol, otherwise the list will not appear, instead only the name entered will appear> 7) Fill the other Validation tabs if required. 8) Click OK. You will notice that the range that you wanted will appear in the list. I have also attached a worksheet to desctibe this example. Regards, Andy On Tue, Jun 30, 2009 at 11:32 PM, Sastry <[email protected]> wrote: > Name: Sastry B > Tip: How to use a combo box. (Excel attached for clarity) > > This must be very useful for all those who are in MNCs and have to show > their financial/economic nos. in more than one currency. This comes > extremely handy. > > I have written the core tip in this attachment. You can put more controls > and also can put one sheet for "parameters" where you can change the key > nos. > > regards, > Sastry > > 2009/6/30 Ayush Jain <[email protected]> > >> >> Dear Members, >> >> Thanks for your great response in the Week 26 competition. It was >> again great learning for the members of the group. >> Let us begin week # 27 quiz with the more spirit. This is last chance >> for you to be eligible for June month competition.The winner of week # >> 26 will be declared soon. Keep watching this Space...... >> >> Last Date of Submission of tips : 5th July 2009. >> >> PLEASE NOTE THAT THE TIPS SUBMITTED IN THIS POST WILL ONLY BE >> CONSIDERED FOR PRIZES. >> DO NOT START NEW THREADS OR POST FOR SUBMISSION OF TIPS. >> >> You need to submit your name, Subject & the details of tips and >> tricks. >> DO let me know if you need any clarifications. >> >> Let me begin by submitting the first tip for this week competition. >> >> --------------------------------------------------------------------------------------------------------------------------------------------------- >> Name : Ayush Jain >> Subject : Skip through your worksheets with a shortcut >> Detail : When I'm working on many programs at once (yes, of course I'm >> a multitasker — what did you expect?), I use the keyboard shortcut ALT >> +TAB to move between open programs. (If you haven't tried this, do so >> now — it's a great Microsoft Windows® trick.) >> >> However, this doesn't work when you're moving between worksheets in >> the same workbook. Don't despair; there are a couple of neat little >> shortcuts that handle the job quite nicely. >> >> To move one worksheet to the right >> >> Press CTRL+PAGE DOWN. >> >> To move one worksheet to the left >> >> Press CTRL+PAGE UP. >> >> Now you can skip through those worksheets with lightning speed and >> amaze your friends and coworkers (if they're the type to be amazed by >> that sort of thing, of course). >> >> Who is next ???????????????????? >> >> ----------------------------------------------------------------------------------------------------------------------------------------------------- >> >> >> --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Valid.xls
Description: MS-Excel spreadsheet
