Hi,

Thanks for both of those suggestions, I will have a play and see which
solution works best for me.

Cheers,

Aaron.
Max wrote:
Just some thoughts, not sure ..

Supposing your set of numbers are in a named col range, eg:
MyRange: =Sheet1!$A$1:$A$10

You could then create data validation droplists in any sheet via selecting
the desired range, then clicking Data Validation, Allow: List, Source:
=MyRange. The DV droplists will show your set of numbers for easy selection.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Slashman" wrote in message
oups.com...
Hi,

I have a set of numbers in a column that are a standard set of numbers
that my other numbers are referred to. How can I auto pull in the set
of numbers without having to type them all in all the time when I use
different standards for my calculations to refer to?

Can I chose a set of numbers based on say selecting a radio button on
the sheet and then hitting a macro launching button to pull them in
perhaps?

Cheers in advance,

Aaron.