balances in a single worksheet
Hello everyone,
I have 26 customer account excel files on a network drive (shared) and
I would like to create an excel file on my computer that shows all of
my customer balances in a single worksheet. I tried doing this by using
links.
My problem is that every customer's balance changes cell daily. For
example if customer A's balance value was in cell H6, the next day it
will be in cell H7 and so on. Therefore the links in my computer excel
file are not updated.
I would really appreciate it if anyone could help out,
Thanx in advance,
gianni
--
spartan111
|