| 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 ? |
| 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 | |||
Threaded Mode
