Not sure where to go from here with returning a cell's comment to the master sheet after it has been matched with the source sheet name and cell number.
Master Sheet:
Cell B2 >> List of sheet names minus the Master Sheet
Cell C2 >> Using a named range will return a data validation list for the sheet selected in B2
Cell E2 >> Want to return the comment from the cell chosen in B2/C2 if one is present, if not, blank is fine.
Currently in cell E2, a UDF has been used to point directly to the cell on Sheet2 where 49 is found, but how can this be made dynamic so it picks up any comment for any cell in the range of the sheet that is selected in B2?
This would be one Sheet and one cell at a time. So if B2 was Sheet6 and C2 I would expect to get the comment from cell A21 on Sheet6.
Bookmarks