Kevin,

I have a question then in regards to this. I have been using this formula
to reference data from a specific document. The only problem I am coming
across is the fact that the formula doesn't automatically add to the row
number when I try to copy them. Is there a way to have this done?

Here is the situation. I have a LARGE workbook with multiple worksheets of
data that I need to reference on a per 'customer' basis. In each worksheet
there can be upwards to 600+ rows of data and I am at IT in the column
naming. So you can understand the numbers I am working with. I have only
referenced specific columns for this new document but I need all of the rows.
It's kind of a pain to have to go through each cell to add from row 6 to 7
to 8 and so on. I was hoping it would act more like the typical formula
where it auto sequences during the copying step.

Of course I have to redirect to the base workbook each time. It would save
me weeks worth of time on this. Literally!

Thanks,

Mike

"Kevin B" wrote:

You can use formulas to reference values in other workbooks:

=[AutoAmort.xls]Sheet1!$C$7

Generically speading:

=[WorkbookName.ext]SheetName!CellAddress
--
Kevin Backmann


"tel" wrote:

Is it possible for Excel to transfer data from one workbook to specific cells
in another workbook. I am using Office Home and Student 2007, do I need any
extra software?
--
tes