Hi,
I referred this Fetch all the smart markers in the excel template for fetching a smart marker from a sheet. Now, is it possible to get the cell names of the cells referred by a smart marker? Those cells maybe in the same sheet or other sheet in the same workbook.
Eg1. if the smart marker in a cell is
&=&=TEXT(DataSheet!A{r},“MM/DD/YYYY”)
Then I want to extract the sheet name and column name: DataSheet!A
Eg2. &=&=IF(OR(DataSheet!G{r}=“”,DataSheet!G{r}=0),“”,DataSheet!X{r})
It should give me this:
DataSheet!G
DataSheet!X
Eg3. &=&=IF(OR(J{r}=0,J{r}=“”),“”,ROUND((J{r}*250)/G{r}*100,2))
It should give:
Sheet1!J or J
Sheet1!G or G (where Sheet1 is the sheet containing this marker)
Is there a way to do this?