Data Transfer

[tel]

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?

 

[Kevin B]

You can use formulas to reference values in other workbooks:

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

Generically speading:

=[WorkbookName.ext]SheetName!CellAddress

 

[Dave Peterson]

You could open both workbooks and then
select the range to copy
ctrl-c (to copy the range)
select the topleft cell in the destination range
ctrl-v (to paste)

 

[Mike K]

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

You can use formulas to reference values in other workbooks:

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

Generically speading:

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

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?

 

[Kevin B]

By default formulas that reference external workbooks are entered as absolute
cell addresses. The "$" before the column and row in the sample formula's
cell reference to C7 informs Excel to not adjust column or row if the formula
is copied, always reference cell C7.

Example:

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

REmoving the "$" from the cell reference makes it a relative reference, and
will adjust both column and row when copied.

Example:

=[AutoAmort.xls]Sheet1!C7

Cell references come in 4 flavors:

Relative, which is the default (A1)
Absolule column, relative row($A1)
Absolute row, relative column (A$1)
Absolute row and column ($A$1)


--
Kevin Backmann

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

You can use formulas to reference values in other workbooks:

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

Generically speading:

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

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?

 

[Mike K]

Thank you sir, that did the trick. I appreciate your help.

Mike

By default formulas that reference external workbooks are entered as absolute
cell addresses. The "$" before the column and row in the sample formula's
cell reference to C7 informs Excel to not adjust column or row if the formula
is copied, always reference cell C7.

Example:

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

REmoving the "$" from the cell reference makes it a relative reference, and
will adjust both column and row when copied.

Example:

=[AutoAmort.xls]Sheet1!C7

Cell references come in 4 flavors:

Relative, which is the default (A1)
Absolule column, relative row($A1)
Absolute row, relative column (A$1)
Absolute row and column ($A$1)


--
Kevin Backmann

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

You can use formulas to reference values in other workbooks:

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

Generically speading:

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


:

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?