Hi,

I was wondering if the following is possible. In the workbook is the following snippet of code transferring some info (read) from a set of active workbooks to a master workbook (write).

Please Login or Register  to view this content.
Is it possible for this method to have the values linked? as in if the first workbook changes then the second will automatically update?

I know you can do this when pasting i.e use

Please Login or Register  to view this content.
But can it be done using the above method?

Thanks for any help!