I've got 20 separate workbooks, each of which has identical formulas and tables, but with individual sets of data (stocks). The formulas are part of a trading strategy.
Each workbook has an input table of about 20 rows (the "Input Table"), where I can adjust variables in the trading formulas.
I now am creating a "master" workbook which is going to have its own 20-row Input Table. The values in this table would then be copied/linked to each of the 20 individual workbooks.
Therefore... if cell B25 of the Master workbook is 7, then cells B25 of each of the 20 individual workbooks will also be 7.
I tried writing a simple formula but just using an = sign doesn't carry over from one workbook to another. I'm assuming that I need to use some kind of link to make this work but I don't know how to do it.
Any suggestions?
Thank you.
Bookmarks