Excel 2007 : Define name,Name Boxes

[Piticu]

Hi,has anyone got idea how could i use this names NIKE AIR* PEGASUS+ 26 (GS/PS) and PUMA 2,9 WN S SEASONAL in Name Box??Underline didn't help me,period too .Thanks

[jeffreybrown]

This might help...

Learn about syntax rules for names
The following is a list of syntax rules that you need to be aware of when you create and edit names.

Valid characters The first character of a name must be a letter, an underscore character (_), or a backslash (\). Remaining characters in the name can be letters, numbers, periods, and underscore characters.
Note You cannot use the uppercase and lowercase characters "C", "c", "R", or "r" as a defined name, because they are all used as a shorthand for selecting a row or column for the currently selected cell when you enter them in a Name or Go To text box.

Cell references disallowed Names cannot be the same as a cell reference, such as Z$100 or R1C1.
Spaces are not valid Spaces are not allowed as part of a name. Use the underscore character (_) and period (.) as word separators, such as, Sales_Tax or First.Quarter.
Name length A name can contain up to 255 characters.
Case sensitivity Names can contain uppercase and lowercase letters. Excel does not distinguish between uppercase and lowercase characters in names. For example, if you created the name Sales and then create another name called SALES in the same workbook, Excel prompts you to choose a unique name.

[Piticu]

I used that,but stil something's wrong and I can't figure out what ...

[jeffreybrown]

What about the error message you should have recieved after pressing OK...

Probably #2 >> Invalid characters

This works...

NIKE_AIR_PEGASUS_26_GS_PS

[Piticu]

it works,but the drop down menu with INDIRECT and SUBTITUTE doesn't work

[jeffreybrown]

If you would like to post your workbook I'd be happy to take a look.

[Piticu]

Here you are! I have to finish OBJEDNAVKA list.It's in Czech If you need to trnslate something I'll help you

[jeffreybrown]

Hi Piticu,

Question? On the OBJEDNAVKA tab, in cell C3 the user will select a name, NIKE AIR* PEGASUS+ 26 (GS/PS).

In C5 you want to see the Velikost of 37, 38, and 38.5. Is this correct?

If so, from what tab?

[Piticu]

From Sheet1 tab.In Sheet1 tam i put all the sizes! and work all except those (GS/PS) and PUMA 2,9 WN S SEASONAL,because i can't put them in Name Boxes

[jeffreybrown]

Why don't you just pull the sizes right from one of the sheets?

In the name manager >> New >> MyVelikost >> =OFFSET(ZBOZI!$B$1,MATCH(OBJEDNAVKA!$C$3,Název_zboží,0),1,COUNTIF(Název_zboží,OBJEDNAVKA!$C$3))

In C5 on the OBJEDNAVKA tab >> for the data validation >> =MyVelikost

See if this is something you can work with.

I will be away from my computer for the next 5 hours or so, but I check back in as soon as possible.

[Piticu]

I've got no idea what that code means,but it works! :D