You could use this UDF to show the sheet and address

Function showfn(myCell)
If myCell.HasFormula Then
showfn = Mid(myCell.Formula, 2)
Else
showfn = ""
End If
End Function

i.e. =showfn(A1) would return Sheetname!cellref

Alternative...........

=LEFT(showfn(A1),FIND("!",showfn(A1))-1) would return just the Sheetname


Gord Dibben MS Excel MVP

On Thu, 25 Sep 2008 11:16:18 -0700, RedFive
wrote:

Well, I am trying to create a column in a master sheet that will specify
which sheet in the workbook the corresponding information in the same row was
pulled from. So if the information in the row A1:F1 was linked from Sheet1,
I would like a column that displays "Sheet1"
Does that make sense or make it worse?