Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.

Hi James,

You could do it by writing a formula in cell A1 (for example) of each sheet,
linking back to the sheet that you update. Like:
=Sheet1!A1

Where Sheet1!A1 is the cell that you update.

hth
BigPig

"James" wrote:

Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.

Hi James,

I'm sorry, just reread your post.

Yes, but you'd have to use vba.

"James" wrote:

Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.

On Aug 30, 10:06 am, BigPig wrote:
Hi James,

I'm sorry, just reread your post.

Yes, but you'd have to use vba.



"James" wrote:
Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.- Hide quoted text -

- Show quoted text -

Thanks, do you happen to know how to write that code? Thanks.

James, if the workbooks you want to update are not open, then Bob Phillips'
article on SUMPRODUCT might be useful to you.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
See the Advantages of SUMPRODUCT section. Note that SUMPRODUCT can refer to
a single cell, if desired. James

"James" wrote in message
ups.com...
On Aug 30, 10:06 am, BigPig wrote:
Hi James,

I'm sorry, just reread your post.

Yes, but you'd have to use vba.



"James" wrote:
Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.- Hide quoted text -

- Show quoted text -

Thanks, do you happen to know how to write that code? Thanks.