I have a table:
A2: 2021_010
A3: 2021_011
A4: 2021_012
and so on
in each line I would like to get data from another excel with the following:
for B2:
'D:\folder\2021\2021_010\[2021_010_A- A.xlsx]Sheet1'!$G$10
for B3:
'D:\folder\2021\2021_011\[2021_011_A- A.xlsx]Sheet1'!$G$10
for B4:
'D:\folder\2021\2021_012\[2021_012_A- A.xlsx]Sheet1'!$G$10
There are hundreds of data in column A, so I would like to create an automatic function to column B.
Thanks
A2: 2021_010
A3: 2021_011
A4: 2021_012
and so on
in each line I would like to get data from another excel with the following:
for B2:
'D:\folder\2021\2021_010\[2021_010_A- A.xlsx]Sheet1'!$G$10
for B3:
'D:\folder\2021\2021_011\[2021_011_A- A.xlsx]Sheet1'!$G$10
for B4:
'D:\folder\2021\2021_012\[2021_012_A- A.xlsx]Sheet1'!$G$10
There are hundreds of data in column A, so I would like to create an automatic function to column B.
Thanks