Nov 14 2019 04:41 AM
Hi,
Just would like to have some advice.
I have a workbook which contains price information (Workbook A).
This info will be shared with others except 1 column which contains price info (Workbook B).
Also, if any data change in A, i would like to make B updated automatically.
So, i set linked cells in B, but it took too much time to open the file due to too many linked cells (many columns & rows in A.
I appreciate if i could have any advice to make automatic update from A to B.
One option is VBA by copy&paste selected columns, but would like to know if there's any other method.
Thanks in advance.
Dai