| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing data from other workbooks | Excel Discussion (Misc queries) | |||
| Importing information from 2 workbooks into a 3rd one | Links and Linking in Excel | |||
| Importing information from 2 workbooks into a 3rd one | Excel Worksheet Functions | |||
| Importing information from 2 workbooks into a 3rd one | Excel Discussion (Misc queries) | |||
| Importing Workbooks into a Master Workbook | Excel Worksheet Functions | |||
Linear Mode
