Max, I wonder if you can suggest how I can link column 1, sheet A in workbook
A, to all the Sheet A's in workbooks 2-25, so that if I change any column A
cell in Workbook 1, and then open any of the other workbooks, each of their
Sheet A cell contents will be updated to echo the change, AND also so that if
rows are inserted in Workbook A sheet A, those rows will also become inserted
in all the Sheet A's in the other workbooks...upon opening them...
I've tried Insert Link, and it works for the cell contents, but it doesn't
seem to work for automatically picking up added rows.
"Max" wrote:
Glad it worked out well for you, Bob
and we had fun, too, along the way ! <g
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"BobW" wrote in message
...
Max, you genius, i owe you a virtual beer!!!
By the way, just for fun I tried it without first killing all the previous
formulas in the slave sheets....guess what? It wasn't necessary; when I
add
a new row using your buttion, it's reflected on all slave sheets AND the
new
row on the slave sheet inherits the 'copied down' formula automatically so
not only does the new row go in fine, but its new name replicates through
all
the slave sheets, too. Just what I wanted!
Incidentally, the actual workbook has about 22 slave sheets, so I had to
add
all their names into your array string function.
This is just wonderful; thank you for the lesson. You are a good teacher!