J
James
Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.
the same time? Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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
G
Guest
Hi James,
I'm sorry, just reread your post.
Yes, but you'd have to use vba.
I'm sorry, just reread your post.
Yes, but you'd have to use vba.
J
James
Hi James,
I'm sorry, just reread your post.
Yes, but you'd have to use vba.
- Show quoted text -
Thanks, do you happen to know how to write that code? Thanks.
Z
Zone
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
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