Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cross-reference data from one file to another file
i have 2 files a.xls and b.xls
i wanna cross-reference data from a.xls to b.xls such that when i drag , values in cell A1 to A10(referenced from a.xls) will be filled automatically in cell A1 to A10 of b.xls. Currently, when i drag the cell A1, what it does is just duplicating A1 values all the way to cell A10. How do i set it such that it will perform in the way i hope ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cross-reference data from one file to another file
"Zancouth" wrote in message
... i have 2 files a.xls and b.xls i wanna cross-reference data from a.xls to b.xls such that when i drag , values in cell A1 to A10(referenced from a.xls) will be filled automatically in cell A1 to A10 of b.xls. Currently, when i drag the cell A1, what it does is just duplicating A1 values all the way to cell A10. How do i set it such that it will perform in the way i hope ? Click in A1 of b.xls, type =, then go to a.xls & click in A1. Then accept the formula in b.xls, which should be saying something like: =[a.xls]Sheet1!$A$1 If it does say $A$1, change this to $A1 (removing the dollar sign before the 1). Accept this change, & drag down through A2 to A10. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |