| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create a macro, that references another excel file ???
I have (2) excel files. I would like to create a macro in (1) file, to
reference a cell in the other excel file. I export the data into the first spreadsheet via quickbooks. The problem is that the imported data is seldon in the same cell range. So how can I reference the same data, that is in different cells? I have never written a macro in Excel. Aries |
|
#2
|
|||
|
|||
|
Hi Aries
You will have to post a lot more info, before anyone will be able to help you! "Aries" wrote: I have (2) excel files. I would like to create a macro in (1) file, to reference a cell in the other excel file. I export the data into the first spreadsheet via quickbooks. The problem is that the imported data is seldon in the same cell range. So how can I reference the same data, that is in different cells? I have never written a macro in Excel. Aries |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro vba relative references | Excel Worksheet Functions | |||
| How do I create a macro to return drop down boxes to first item i. | Excel Discussion (Misc queries) | |||
| How can I create drop-down lists with references in other workboo. | Excel Worksheet Functions | |||
| Macro to create macro | Excel Discussion (Misc queries) | |||
| How do I create a macro of editing keystrokes? | Excel Discussion (Misc queries) | |||
Linear Mode
