Excel

Resolved · Low Priority · Version Standard

Excel

Chantel has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Chantel [3 posts] (2008 Mar 11 Tue, 16:26) Reply

i would like to know how to create drop down boxes listing information from another sheet.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
2007	2008 Dec 10 Wed	Bloomsbury	2	book now	£240	£245
2003	2008 Dec 12 Fri	Southwark	3	book now	£224	£235
2003	2008 Dec 17 Wed	Southwark	0	FULL
2003	2008 Dec 17 Wed	Bayswater	0	FULL
Full Schedule: See all 94 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel

by - delegate Samantha [21 posts] (2008 Mar 13 Thu, 13:00) Edited on 2008 Apr 9 Wed, 16:25 Reply

name the list which you have created.

Do this by selecting the list and then clicking on the top left hand address cell (where it normally says A1) and change this to the Name of the list "MyList" for example.

Then go to the cell that you want to have the drop down list. Click on Data and then Validation, and click on the Settings tab.

Choose "List" in the Allow box,
in Source, enter the name of your list but preceded with an = sign i.e. =MyList

You should then see that that cell becomes a drop down box.

i got this a few months ago from this web site.

http://office.microsoft.com/en-us/excel/HP052022151033.aspx

· From the Classroom to the Corporate World
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Advanced level training: Microsoft Excel and the Web
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips

Rate this page: