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".