View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
spartan111 spartan111 is offline
external usenet poster
 
Posts: 1
Default 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