Hello everyone. I was wondering if it were at all possible to import the
values from one workbook to another workbook without having to copy and paste
everything over and over again. The reason I ask is because I have to do
this every night and it is causing me to lose my mind with all the new
numbers I have to put in every day. Thanks for any help.

Have you tried saving it as the new workbook?

"Phantom1219" wrote:

Hello everyone. I was wondering if it were at all possible to import the
values from one workbook to another workbook without having to copy and paste
everything over and over again. The reason I ask is because I have to do
this every night and it is causing me to lose my mind with all the new
numbers I have to put in every day. Thanks for any help.

Well here's what I want to do. I have this one WB that has all these
formulas and they have the end values that I need. I have another WB that I
have to input all of the generated values from the first WB. The thing is
the values are from different sheets in the first WB. What I want to know is
there anyway that I can type in a formula and have it search the first WB for
the appropriate cell and input that info, thereby reducing time spent looking
for the info. By the way I am using Excel 03. Thanks again for the help.

"Carole Drake" wrote:

Have you tried saving it as the new workbook?

"Phantom1219" wrote:

Hello everyone. I was wondering if it were at all possible to import the
values from one workbook to another workbook without having to copy and paste
everything over and over again. The reason I ask is because I have to do
this every night and it is causing me to lose my mind with all the new
numbers I have to put in every day. Thanks for any help.