course excel training vba london

course excel training vba london - V look up

Resolved · Low Priority · Version Standard

V look up

Matthew has attended:
Excel Intermediate course

by - delegate Matthew [2 posts] (2008 Jan 9 Wed, 11:24) Reply

How do I assign names to data in a huge data list?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: V look up

by - trainer Amanda diamond contributer [1243 posts] (2008 Jan 11 Fri, 13:21) Reply

Hi Matthew

Thank you for your question, and apologies for the delay in reply.

You can assign names to cell ranges by doing the following:

1. Select the cell range you wish to name
2. Click in the Name box (near the top of your screen, under the box where you choose the font type).
3. Enter a name for the range, without using spaces as part of the range name
4. Press Enter to assign the name to the cell range.

To edit the cell range that the name refers to:
1. Go to Insert/Name/Define
2. Select the name of the range from the large box.
3. Use the Refers to: box at the bottom of the dialogue box to reselect the cell range.
4. Click OK.

You can also add and delete named ranges from within the same dialogue box.

I hope this helps.
Amanda