Importing Dynamic data

  • Thread starter Thread starter omegared
  • Start date Start date
O

omegared

Hi

I have some tables in various xl files, call the files a,b and c. I
want to import all these into a single xl file called e. If changes are
made to a,b or c I want it to automatically update e.

I have used the import function in d but if I change a,b or c to see
the change I have to select the data in d and press refresh.
Furthermore when I refresh d i have to have files a,b and c open
otherwise it says connection lossed and is unable to refresh the data.

Can someone explain to me in simple terms what I have to do in order to
get the data automatically updated without having to always keep the
files open and refreshing the data.

Thank you in advance.
 
use a database to store your data and use excel as a reminder about how
we used to do screwed up math.

it's 2005 not 1995; excel is dead
 
Back
Top