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("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.
Bookmarks