excel - 交叉引用另一个工作簿(cross referencing to another workbook)

Question

I want "Main.xlsx"."Sheet1".A1 == Workbook2."Sheet2".B1

(我想要“ Main.xlsx”。“ Sheet1” .A1 == Workbook2。“ Sheet2” .B1)

Instead of reading the value of B1 in A1, I would like to store the address of the B1 in A1, so anytime Sheet2 is changed, A1 gets updated automatically.

(我不想在A1中读取B1的值，而是将B1的地址存储在A1中，因此，只要更改Sheet2，A1就会自动更新。)

How can I do this?

(我怎样才能做到这一点？)

  ask by neo_vba translate from so

Answer 1

等待大神答复