Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Read data from anohter XLS file
Does anyone know how to read data from another Excel XLS file and copy it
into a new Excel XLS file? Thanks, John |
#2
|
|||
|
|||
Your question is not clear to me? What exactly do you want to do? You can
just copy over data, or you can use formulas to extract data from another workbook.. Regards, Peo Sjoblom "John Whitehead via OfficeKB.com" wrote: Does anyone know how to read data from another Excel XLS file and copy it into a new Excel XLS file? Thanks, John |
#3
|
|||
|
|||
Peo Sjoblom,
What I want is this: File 1 will read all the data from File 2 and place the data into File 1. File 1 will sort the data. Thanks, John |
#4
|
|||
|
|||
John Whitehead via OfficeKB.com wrote...
Does anyone know how to read data from another Excel XLS file and copy it into a new Excel XLS file? Opening both files, copying from one and pasting into the other isn't an option for you? |
#5
|
|||
|
|||
I would like the Excel spreadsheet to do this. The person I'm trying to
help needs to take classes on Excel. Thanks, John -- Message posted via http://www.officekb.com |
#6
|
|||
|
|||
John Whitehead via OfficeKB.com wrote...
I would like the Excel spreadsheet to do this. The person I'm trying to help needs to take classes on Excel. You could pull in data with formulas like =IF(ISBLANK('X:\Y\[Z.xls]SomeSheet'!A1),"",'X:\Y\[Z.xls]SomeSheet'!A1) Pulling data by formula or copy/paste are your only alternatives. |
#7
|
|||
|
|||
Biff suggested I check out responses on this as there may be a VBA routine
that does this. I want to take the formula below and in place of the file name have a variable value that looks up the data on another workbook while it is closed. example: A1 = June.xls B1 = =IF(ISBLANK('X:\Y\[A1]SomeSheet'!A1),"",'X:\Y\[A1]SomeSheet'!A1) the value in A1 can potentially change depending on other factors within the active sheet. But the value in B1 is always based off of the file name in A1. I would prefer to do this in a formula or array if at all possible instead of setting a VBA routine to enter this formula everytime the page is opened. "Harlan Grove" wrote: John Whitehead via OfficeKB.com wrote... I would like the Excel spreadsheet to do this. The person I'm trying to help needs to take classes on Excel. You could pull in data with formulas like =IF(ISBLANK('X:\Y\[Z.xls]SomeSheet'!A1),"",'X:\Y\[Z.xls]SomeSheet'!A1) Pulling data by formula or copy/paste are your only alternatives. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Dowloading internet data to worksheet form a ".ccv" file | Excel Worksheet Functions | |||
import external data from changing file name | Excel Worksheet Functions | |||
how do i open a file in excel that is encrypted or read only | Excel Discussion (Misc queries) | |||
Import Excel Data from another workbook or file | Excel Discussion (Misc queries) |