Updated Cells in different workbooks
 

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

Updated Cells in different workbooks
 

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.

Updated Cells in different workbooks
 

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.

Updated Cells in different workbooks
 

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.

Updated Cells in different workbooks
 

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.