View Single Post
  #1   Report Post  
Aries
 
Posts: n/a
Default 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