Data from Worksheet to Worksheet
 

Hi, I'm desperately searching for a way and was wondering if it was
possible to take data from one worksheet and utilize it in another
one. If so, is there a macro or is there a simpler way to do it or
even if there is a macro, what could it be to get it to function, I'm
not even a beginner at programming as I am fairly new to it so I need
a little bit of help.

Data from Worksheet to Worksheet
 

On Jun 26, 1:13 pm, wrote:
Hi, I'm desperately searching for a way and was wondering if it was
possible to take data from one worksheet and utilize it in another
one. If so, is there a macro or is there a simpler way to do it or
even if there is a macro, what could it be to get it to function, I'm
not even a beginner at programming as I am fairly new to it so I need
a little bit of help.

You could just create a data connection to the worksheet that has the
data you want to access. I'd put the data connection on its own sheet
in your workbook. Not sure what version of Excel you're using, but
using Excel 2007 just click the Data menu option and create the
connection using "From Microsoft Query". You would tell it to use
Excel as the data source and then follow the wizard.

Depending on what you're trying to do, it might be easier just to
reference cells in the other workbook. The easiest way to see how to
do that is to have both workbooks open and then enter "=" in one
spreadsheet, then click on a cell in the other. You should end up with
something like "=[workbook1.xs]Sheet1!$A$1".

Data from Worksheet to Worksheet
 

On Jun 26, 2:32 pm, Ferris wrote:
On Jun 26, 1:13 pm, wrote:

Hi, I'm desperately searching for a way and was wondering if it was
possible to take data from one worksheet and utilize it in another
one. If so, is there a macro or is there a simpler way to do it or
even if there is a macro, what could it be to get it to function, I'm
not even a beginner at programming as I am fairly new to it so I need
a little bit of help.

You could just create a data connection to the worksheet that has the
data you want to access. I'd put the data connection on its own sheet
in your workbook. Not sure what version of Excel you're using, but
using Excel 2007 just click the Data menu option and create the
connection using "From Microsoft Query". You would tell it to use
Excel as the data source and then follow the wizard.

Depending on what you're trying to do, it might be easier just to
reference cells in the other workbook. The easiest way to see how to
do that is to have both workbooks open and then enter "=" in one
spreadsheet, then click on a cell in the other. You should end up with
something like "=[workbook1.xs]Sheet1!$A$1".

Appreciate the help Ferris, I'm utilizing Excel 2003 and tried your
formula, but it comes up with the answer #REF and a load/open box
telling me to update values comes up.

Data from Worksheet to Worksheet
 

On Jun 26, 2:38 pm, "Ahh, Excel's Tough"
wrote:
On Jun 26, 2:32 pm, Ferris wrote:





On Jun 26, 1:13 pm, wrote:

Hi, I'm desperately searching for a way and was wondering if it was
possible to take data from one worksheet and utilize it in another
one. If so, is there a macro or is there a simpler way to do it or
even if there is a macro, what could it be to get it to function, I'm
not even a beginner at programming as I am fairly new to it so I need
a little bit of help.

You could just create a data connection to the worksheet that has the
data you want to access. I'd put the data connection on its own sheet
in your workbook. Not sure what version of Excel you're using, but
using Excel 2007 just click the Data menu option and create the
connection using "From Microsoft Query". You would tell it to use
Excel as the data source and then follow the wizard.

Depending on what you're trying to do, it might be easier just to
reference cells in the other workbook. The easiest way to see how to
do that is to have both workbooks open and then enter "=" in one
spreadsheet, then click on a cell in the other. You should end up with
something like "=[workbook1.xs]Sheet1!$A$1".

Appreciate the help Ferris, I'm utilizing Excel 2003 and tried your
formula, but it comes up with the answer #REF and a load/open box
telling me to update values comes up.- Hide quoted text -

- Show quoted text -
Nevermind about that one Ferris, I got it to work, but is there any
possible way I can get it a whole formula into one cell? For example,
I want to put the equation
=IF(A2<=0,"0",=PRODUCT([YearlySummary.xls]Lookup!$B$3) times 8. Is it
possible that you can translate the equation to excel language?