ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dependant List (https://www.excelbanter.com/excel-programming/385136-dependant-list.html)

Neels

Dependant List
 
I am making a dependant list with A/C types and Registrations. The problem
is that some A/C types, eg. C172, BE20, can not be turned into names in the
Names Block since they are also block numbers on excel. Is there a way
around this?

Jim Rech

Dependant List
 
You'll have to use something that is 'close enough'. How about _C172?

--
Jim
"Neels" wrote in message
...
|I am making a dependant list with A/C types and Registrations. The problem
| is that some A/C types, eg. C172, BE20, can not be turned into names in
the
| Names Block since they are also block numbers on excel. Is there a way
| around this?



Neels

Dependant List
 
Thanks Jim

I am doing that at the moment. I just hoped there might be another way.

"Jim Rech" wrote:

You'll have to use something that is 'close enough'. How about _C172?

--
Jim
"Neels" wrote in message
...
|I am making a dependant list with A/C types and Registrations. The problem
| is that some A/C types, eg. C172, BE20, can not be turned into names in
the
| Names Block since they are also block numbers on excel. Is there a way
| around this?





All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com