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
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
--
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
, 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
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
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