copy a set of names(constants) from 1 workbook to another
 

Hi,

I tried to figure out how to do this but I'm stumped!

I have a worksheeet where I have defined a set of names and values like
H2_gas =34356.87
O2_gas=14523.14
I do this by using "DefineName" and directly typing the name and the value
it should stand for. Essentially these are constants and don't change. I just
needed a convinient way to refer to them.

Now I am starting a new workbook where I'd like to be able to refer to these
values. Whats a neat way to do this? If possible I wanted to have them
redifined as constants and not as cell refernces(just as I had done manually
in the original worksheet) to avoid the chance of inadverent changes at some
later date...

ANy sugesstions?

Thanks!

-Rahul

Just drag and drop a sheet from the first workbook to the second.

--
HTH

Bob Phillips

"Rahul" wrote in message
...
Hi,

I tried to figure out how to do this but I'm stumped!

I have a worksheeet where I have defined a set of names and values like
H2_gas =34356.87
O2_gas=14523.14
I do this by using "DefineName" and directly typing the name and the value
it should stand for. Essentially these are constants and don't change. I
just
needed a convinient way to refer to them.

Now I am starting a new workbook where I'd like to be able to refer to
these
values. Whats a neat way to do this? If possible I wanted to have them
redifined as constants and not as cell refernces(just as I had done
manually
in the original worksheet) to avoid the chance of inadverent changes at
some
later date...

ANy sugesstions?

Thanks!

-Rahul

Thanks! That worked perfect! Exactly what I wanted.

-Rahul

"Bob Phillips" wrote:

Just drag and drop a sheet from the first workbook to the second.

--
HTH

Bob Phillips

"Rahul" wrote in message
...
Hi,

I tried to figure out how to do this but I'm stumped!

I have a worksheeet where I have defined a set of names and values like
H2_gas =34356.87
O2_gas=14523.14
I do this by using "DefineName" and directly typing the name and the value
it should stand for. Essentially these are constants and don't change. I
just
needed a convinient way to refer to them.

Now I am starting a new workbook where I'd like to be able to refer to
these
values. Whats a neat way to do this? If possible I wanted to have them
redifined as constants and not as cell refernces(just as I had done
manually
in the original worksheet) to avoid the chance of inadverent changes at
some
later date...

ANy sugesstions?

Thanks!

-Rahul

My pleasure.

Bob

"Rahul" wrote in message
...
Thanks! That worked perfect! Exactly what I wanted.

-Rahul

"Bob Phillips" wrote:

Just drag and drop a sheet from the first workbook to the second.

--
HTH

Bob Phillips

"Rahul" wrote in message
...
Hi,

I tried to figure out how to do this but I'm stumped!

I have a worksheeet where I have defined a set of names and values
like
H2_gas =34356.87
O2_gas=14523.14
I do this by using "DefineName" and directly typing the name and the
value
it should stand for. Essentially these are constants and don't change.
I
just
needed a convinient way to refer to them.

Now I am starting a new workbook where I'd like to be able to refer to
these
values. Whats a neat way to do this? If possible I wanted to have them
redifined as constants and not as cell refernces(just as I had done
manually
in the original worksheet) to avoid the chance of inadverent changes
at
some
later date...

ANy sugesstions?

Thanks!

-Rahul