Importing range of cell values from several workbooks to one
 

Hello, I am new to Excel, so any help is very appreciated.
I have one workbook with 4 sheets. What I need to do is to import values
from several workbooks in that one.
I need to select the source file and import fixed range of values from that
file, and after that specify place in my workbook where I want to put it.
I tried to import that as external data, but it imports whole sheet, not
values from range of cells.
Thanks in advance.

Importing range of cell values from several workbooks to one
 

Start here
http://www.rondebruin.nl/copy3.htm

Try the add-in
http://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"®eljka Petroviæ" wrote in message ...
Hello, I am new to Excel, so any help is very appreciated.
I have one workbook with 4 sheets. What I need to do is to import values from several workbooks in that one.
I need to select the source file and import fixed range of values from that file, and after that specify place in my workbook
where I want to put it.
I tried to import that as external data, but it imports whole sheet, not values from range of cells.
Thanks in advance.

Importing range of cell values from several workbooks to one
 

Thanks. You solved my problem.


"Ron de Bruin" wrote in message
...
Start here
http://www.rondebruin.nl/copy3.htm

Try the add-in
http://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"®eljka Petroviæ" wrote in message
...
Hello, I am new to Excel, so any help is very appreciated.
I have one workbook with 4 sheets. What I need to do is to import values
from several workbooks in that one.
I need to select the source file and import fixed range of values from
that file, and after that specify place in my workbook where I want to
put it.
I tried to import that as external data, but it imports whole sheet, not
values from range of cells.
Thanks in advance.