• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Is there a function to search for a cell location

Jack-P-Winner

Jack-P-Winner

Member
I have some data in a cell and I can not find where the data is going to or why it is there. Is there a function to search for where the data originates from?

Thanks
 
Hi Larry ,

Data can come into a cell through objects ; you can have either Form controls or ActiveX controls , and cells can receive data from them.

If you don't have any objects in your workbook , then there is only one other way for cells to have data in them i.e. through external data connections.

Narayan
 
In addition to Narayan's comments, Also check

Is the cell/worksheet protected so that it doesn't show the contents?

Have you looked at Conditional Formatting, it may be showing a value dependent on some other cell's value?
 
Hi Larry ,

To continue on Hui's approach , what do you see when you place the cursor in the problem cell(s) ? Do you see data or are they blank ?

If you do see data , is what the formula bar displaying the same as what you see in the cell ?

Narayan
 
Hui said:
In addition to Narayan's comments, Also check

Is the cell/worksheet protected so that it doesn't show the contents?

Have you looked at Conditional Formatting, it may be showing a value dependent on some other cell's value?
Click to expand...


Thanks for all the replies, I have looked in the CF on several of the sheets and have not found the yet but I have another to look at so I appreciate that idea Hui (-:

I do not know of any objects of active X that would be attached to my programs.
In the actual cells of the ones I question I know where they go to. What I am trying to figure out is in columns EU EV EW EX EY EZ where does this data go to? For example Here is =Q14, it has the number 33. I know where it comes from. Also below is the CF for the colors of green and red for even and odd. Do I assume that is all is going on these columns? I find that hard to believe IMHO. Thanks for your help!!
 

Attachments

  • Q14.jpg
    Q14.jpg
    313 KB · Views: 0
  • CF FOR EU EV EW EX EY.jpg
    CF FOR EU EV EW EX EY.jpg
    60 KB · Views: 0
  • EU_EV_EW_EX_EY_EZ.jpg
    EU_EV_EW_EX_EY_EZ.jpg
    277 KB · Views: 0
You must log in or register to reply here.
Back
Top