load range of cells from one file into a different file

[John Keith]

I want to load a range of cells from a spreadsheet in one file into a
spreadsheet in a completely different file. I know how to do this with
a cell by cell reference to the cells in the different file but I'm
wondering if I can simplify this by using a named range.I'm not
experienced with using named ranges and so far all my attempts have
failed.

Also, I would be interested to know if cell formats can be transferred
in addition to the cell contents?

Thanks for some tips.


John Keith
(e-mail address removed)

 

[Peo Sjoblom]

Select the range, copy it, go to the new workbook, select the first cell, do
edit>paste special and select paste link
then do edit paste special again and select formats

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[John Keith]

Select the range, copy it, go to the new workbook, select the first cell, do

edit>paste special and select paste link
then do edit paste special again and select formats

Peo,

Thank you for your reply. As usual my first post did not give an
important detail of what I am trying to do. What I think you described
is the manual operation to copy the cells (and their formats) to a new
spreadsheet. I would like to do this same operation but automatically
with a function in the destination spreadsheet that extracts the info
from the source spreadsheet. Automatically carrying the formats
forward would be a plus but not mandatory. I am able to automatically
copy cell by cell using a formaula like:

='C:\path\[source.xls]Sheet 1'!$A$1

and with cut and paste put this into each cell of the destination
workbook but I was curious to know if I could simplify that process
with a range name to get all the cells of interest????





John Keith
(e-mail address removed)

 

[Peo Sjoblom]

My method will do the same, that is put a formula in the destination cells
and it can be used on more than one cell, you only have to do it once since
it will exactly what you are doing now but for multiple cells
Try it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

Select the range, copy it, go to the new workbook, select the first cell,
do
edit>paste special and select paste link
then do edit paste special again and select formats

Peo,

Thank you for your reply. As usual my first post did not give an
important detail of what I am trying to do. What I think you described
is the manual operation to copy the cells (and their formats) to a new
spreadsheet. I would like to do this same operation but automatically
with a function in the destination spreadsheet that extracts the info
from the source spreadsheet. Automatically carrying the formats
forward would be a plus but not mandatory. I am able to automatically
copy cell by cell using a formaula like:

='C:\path\[source.xls]Sheet 1'!$A$1

and with cut and paste put this into each cell of the destination
workbook but I was curious to know if I could simplify that process
with a range name to get all the cells of interest????





John Keith
(e-mail address removed)

 

[John Keith]

Try it

Thank you, I have never used the paste link before.



John Keith
(e-mail address removed)