Hi friends,
I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list.
The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes.
To be clear, the Sheetname that has my data is DataDec2018. The Sheetname I am in currently is Dec2018.
OFFSET(DataDec2018!$I$2,,,DataDec2018!$F$3) <-- This works fine, but I'd have to re-type the month for each different tab.
OFFSET("Data"&RIGHT(CELL("filename"),7)!$I$2,,,"Data"&RIGHT(CELL("filename"),7)!$F$3)
This will allow me to have multiple tabs and use the same formula: DataJan2019, DataFeb2019, etc.
Thanks in advance for any assistance provided.
I need to use a formula in the Source: of my Data Validation to include the Sheetname for my drop down list.
The following formula should work if someone can please show me how to properly QUOTE it. I get very confused trying to put quotes within quotes.
To be clear, the Sheetname that has my data is DataDec2018. The Sheetname I am in currently is Dec2018.
OFFSET(DataDec2018!$I$2,,,DataDec2018!$F$3) <-- This works fine, but I'd have to re-type the month for each different tab.
OFFSET("Data"&RIGHT(CELL("filename"),7)!$I$2,,,"Data"&RIGHT(CELL("filename"),7)!$F$3)
This will allow me to have multiple tabs and use the same formula: DataJan2019, DataFeb2019, etc.
Thanks in advance for any assistance provided.