View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.