Prev: count number of columns based on values across a row
Next: how do I attach a jpeg to a cell
From: iBob on 17 May 2010 13:54
I have 50 spreadsheets which calculate aging on past due invoices. I use the
=now and =today functions to determine which accounts are past due.

I created a master sheet which pulls this information and displays it at a
glance.

The problem is: the dates don't update on the 50 seperate sheets unless the
sheet is opened (and then closed).

Is there a way to update the sheets without having to open them all or how
would I create a macro that opens them and then closes them?

Thank you very much for your help! .... Your input is sorely needed

Bob

From: Ron de Bruin on 17 May 2010 17:23
See
http://www.rondebruin.nl/copy4.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm



"iBob" <iBob(a)discussions.microsoft.com> wrote in message news:25E0CDB5-F813-4808-ACEE-780D03AFAC36(a)microsoft.com...
> I have 50 spreadsheets which calculate aging on past due invoices. I use the
> =now and =today functions to determine which accounts are past due.
>
> I created a master sheet which pulls this information and displays it at a
> glance.
>
> The problem is: the dates don't update on the 50 seperate sheets unless the
> sheet is opened (and then closed).
>
> Is there a way to update the sheets without having to open them all or how
> would I create a macro that opens them and then closes them?
>
> Thank you very much for your help! .... Your input is sorely needed
>
> Bob
>
 | 
Pages: 1
Prev: count number of columns based on values across a row
Next: how do I attach a jpeg to a cell