Is such as a folder there are ten form, form is the same, but I don't want to see every form, I want to see is the same form directly, but the inside of the each data are the ten tables, and is there any way to achieve? Thank you all for the great god, help me... This problem has been bothering me for a long time

CodePudding user response:

Directly using the formula can fix:
='D: \ [1. XLS] sheet1'! $A $1 + 'D: \ [2. XLS] Sheet1'! $A $1
This formula to calculate the D: \ 1. XLS and D: \ 2. XLS sheet1 in the form of the sum of cell A1, and so on...

The remaining with VBA to construct the formula, you need should be easy to you? .

CodePudding user response:

Er... To be honest, I don't really understand VBA, I just know about this in VBA, this is my work encounter a problem, is a headache is not on my own