Importing range of cell values from several workbooks to one

[®eljka Petroviæ]

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.

 

[Ron de Bruin]

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

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

 

[®eljka Petroviæ]

Thanks. You solved my problem.

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

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