This should be simple, at least I would think so, but I can't find a way to
do it. I have a workbook that imports data from another workbook, then
populates another sheet with which I produce my output. The output sheet
shows all the appropriate date but the cell reference is simply the link to
another worksheet.

For example: My sheet shows the number 100 but in the cell it reads
=otherworkseet!a1 (the source from which the data is extracted.

I want to find out how I can use find or a formula to show me every cell
that has the 100 in it without converting it to raw data. Simply using Find
does not locate any data. The result may be identical to other cells but it
comes from seperate locations. I will have a few dozen types of data I will
be trying to find in this manner and probably use replace to give the
intended effect, or if it helps me with creating a formula to look things up
automatically I can perhaps create a handy macro. For now, though, I would
be very happy with just being able to find the information more easily than
to manually identify each cell myself. I am also looking to eliminate the
human error that comes along with the manual identification.

Thanks in advance for any help or ideas you might provide!