Hello,
Please forgive me if this was posted elsewhere. I spent most of yesterday trying to find this, but could not.
Anyway, I'm trying to pull information from one of 22 different closed Excel workbooks. The formula would look similar to this: "='[2022 MPS Expenses.xlsm]Jan'!A3". However, I would like the formula to adjust to one of the below formulas based on the value (year) I enter in B6:
"='[2021 MPS Expenses.xlsm]Jan'!A3"
"='[2020 MPS Expenses.xlsm]Jan'!A3"
"='[2019 MPS Expenses.xlsm]Jan'!A3"
"='[2018 MPS Expenses.xlsm]Jan'!A3"
"='[2017 MPS Expenses.xlsm]Jan'!A3" and so on based on the year that I enter in B6.
Is this possible? I would prefer to do this without VBA, but I welcome all suggestions. Thank you all so much for your time.
Please forgive me if this was posted elsewhere. I spent most of yesterday trying to find this, but could not.
Anyway, I'm trying to pull information from one of 22 different closed Excel workbooks. The formula would look similar to this: "='[2022 MPS Expenses.xlsm]Jan'!A3". However, I would like the formula to adjust to one of the below formulas based on the value (year) I enter in B6:
"='[2021 MPS Expenses.xlsm]Jan'!A3"
"='[2020 MPS Expenses.xlsm]Jan'!A3"
"='[2019 MPS Expenses.xlsm]Jan'!A3"
"='[2018 MPS Expenses.xlsm]Jan'!A3"
"='[2017 MPS Expenses.xlsm]Jan'!A3" and so on based on the year that I enter in B6.
Is this possible? I would prefer to do this without VBA, but I welcome all suggestions. Thank you all so much for your time.