I have list of Tables and their field names in sheet 1 like below
Table 1 - T1 Field 1 - T1 Field 2 - T1 Field 3 ...
Table 2 - T2 Field 1 - T2 Field 2 - T2 Field 3 ...
Table 3 - T3 Field 1 - T3 Field 2 - T3 Field 3 ...
In sheet I have drop down which will populate all table values (Table 1, Table 2, Table 3)
If i select Table 1 in drop down(say cell A1), then fields values of correspondind table should get populated in B1, C1 and D1 respetively.
I dont want to use Excel formulas for the same, since they are taking more time for loading. Please guide me how can i write VBA code for the same.
Table 1 - T1 Field 1 - T1 Field 2 - T1 Field 3 ...
Table 2 - T2 Field 1 - T2 Field 2 - T2 Field 3 ...
Table 3 - T3 Field 1 - T3 Field 2 - T3 Field 3 ...
In sheet I have drop down which will populate all table values (Table 1, Table 2, Table 3)
If i select Table 1 in drop down(say cell A1), then fields values of correspondind table should get populated in B1, C1 and D1 respetively.
I dont want to use Excel formulas for the same, since they are taking more time for loading. Please guide me how can i write VBA code for the same.