Re: $$Excel-Macros$$ database concept - Reg
Create a custom list by typing in values Click the Microsoft Office Button , and then click Excel Options. Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists. In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry. Press ENTER after each entry. When the list is complete, click Add. The items in the list that you selected are added to the Custom lists box. Click OK twice. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ database concept - Reg
Make a Custom List for all names From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Tuesday, May 17, 2011 3:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ database concept - Reg Dear Excel Experts I am typing name and place name different worksheets. like anand babu kumar anand kumar babu same worksheet it' shows previous typing names , i want to store all the names in worksheets . when ever i need type get this name for any worksheets just like database -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ database concept - Reg
Dear Ravi, Please have a view on attached Sheet. On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Make a Custom List for all names *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *jmothilal *Sent:* Tuesday, May 17, 2011 3:03 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ database concept - Reg Dear Excel Experts I am typing name and place name different worksheets. like anand babu kumar anand kumar babu same worksheet it' shows previous typing names , i want to store all the names in worksheets . when ever i need type get this name for any worksheets just like database -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards, Prashant Tripathi Engineer-SW Mobile: 0017202597567 Please consider the environment before printing. Immer zielen auf die vollkommene Harmonie des Denkens Wort deed.Always zielen darauf ab, reinigen Sie Ihre Meinung und alles wird gut. Always aim at complete harmony of thought word deed.Always aim at purifying your thoughts everything will be well. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Select_Input_Value_From_List.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ database concept - Reg
how to create custom list , pls help me On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Make a Custom List for all names *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *jmothilal *Sent:* Tuesday, May 17, 2011 3:03 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ database concept - Reg Dear Excel Experts I am typing name and place name different worksheets. like anand babu kumar anand kumar babu same worksheet it' shows previous typing names , i want to store all the names in worksheets . when ever i need type get this name for any worksheets just like database -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ database concept - Reg
it looks like you need a textbook / excel standard manual Go to a bookstore and buy one you can also visit to this sites: http://blog.contextures.com/archives/2010/03/10/sort-it-your-way-with-excel-custom-lists/ http://www.ehow.com/how_5905455_create-custom-list-excel-2007.html http://spreadsheets.about.com/od/excel101/ss/enter_data.htm http://spreadsheets.about.com/od/excel101/ss/enter_data.htm http://oit.utk.edu/scc/HowToUseExcelForDataEntry.pdf http://oit.utk.edu/scc/HowToUseExcelForDataEntry.pdf http://www.timeatlas.com/5_minute_tips/general/excel_data_form_makes_input_easier http://www.timeatlas.com/5_minute_tips/general/excel_data_form_makes_input_easier http://www.internet4classrooms.com/excel_enter_edit.htm http://www.internet4classrooms.com/excel_enter_edit.htm http://www.homeandlearn.co.uk/me/mes10p1.html On Tue, May 17, 2011 at 9:36 PM, jmothilal gjmothi...@gmail.com wrote: how to create custom list , pls help me -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel