building list
 

hello,

excel2003:
i have a range name SPH1 (='Salar'!$I$146:$I$2033)
it will cover all the weekly entry of values fed from our office.

i146 contains the header
i2033 is always empty.
i147:i2032 not empty with values 0+.

after one week the range will increase for about 100.

i need to create a dynamic list in a separate -Sheet1- like under a name of
SPHU (='Sheet1'!B:B).

SPHU must contain only the unique values entered in SPH1.
so, SPHU may look somethiing like this..
B1 will contain the header
B2:B#
e.g.( 0,401,500,502.5,650.33336,700,max!)

I will use this list from Sheet1 to review other existing workbooks -
somekind of validation work.
thanks and regards,
driller
--
*****
birds of the same feather flock together..

building list
 

How is this different from your other posting a few minutes ago?

--
Don Guillett
SalesAid Software

"driller" wrote in message
...
hello,

excel2003:
i have a range name SPH1 (='Salar'!$I$146:$I$2033)
it will cover all the weekly entry of values fed from our office.

i146 contains the header
i2033 is always empty.
i147:i2032 not empty with values 0+.

after one week the range will increase for about 100.

i need to create a dynamic list in a separate -Sheet1- like under a name
of
SPHU (='Sheet1'!B:B).

SPHU must contain only the unique values entered in SPH1.
so, SPHU may look somethiing like this..
B1 will contain the header
B2:B#
e.g.( 0,401,500,502.5,650.33336,700,max!)

I will use this list from Sheet1 to review other existing workbooks -
somekind of validation work.
thanks and regards,
driller
--
*****
birds of the same feather flock together..