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
Then I want to extract the sheet name and column name: DataSheet!A
It should give me this:
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?