Hi folks, question please.
So Col A has the names of tab names in an external file.
Cell B1 shows the formula I need. I want to drag that formula down but I want to change the tab name in each instance.
How would I do this?
So Col A has the names of tab names in an external file.
Cell B1 shows the formula I need. I want to drag that formula down but I want to change the tab name in each instance.
How would I do this?
| ABC | =[F23_Q2FCST_Procurement.xlsx]ABC!$CD$80 |
| DEF | |
| GHI | |
| JKL | |
