how do I get the specific value and location of an input in an excel sheet. something like this='C:\Documents

Question

How do i get a value from a cell in excel and that it also display the location from where the informatio was gotten. Lets say i want to display 54 and when i click on this cell i could see the location from where this information was gotten from.
Sheet one
A B
54 65
65 96

Sheet two
54 (='C:\Documents and Settings\Sheet one\ A1;1)

Im getting the information from A1:1 which is 54 but when I click on it I would like it to show where the information is gotten from.

Answer 1

As far as my concern, that Excel may not have the capabilities to generate what you are looking for,
54 (='C:\Documents and Settings\Sheet one\ A1;1)

The closest possibility is only to return/display the full sheet name
(including the file path), suppose your worksheet is named "MySheet"
C:\Documents and Settings\MySheet.xls

in Sheet2:
=CELL("filename",Sheet1!A1)
Note that the argument to the =CELL function is the word "filename" in quotes, not your actual filename.
This will return:
C:\Documents and Settings\[MySheet.xls]Sheet1

Good luck.

Answer 2

What you ought to use is conditional formatting. opt for the cells, row, or column which you quite desire to electrify. Then pass to format > Conditional Formatting. opt for "cellular Is" then "equivalent to" and positioned a nil interior the final field. Then click on format and set the colour to white (make sure which you do opt for it, the default colour is black yet it would not teach in the start). this could paintings provided that the cellular that incorporates the fee is white as nicely. in any different case, set it to the colour of the cellular's historic past colour. regrettably, it is the closest which you will get to what you like. Jon's answer below probable works extra helpful (the 2nd area). he's best approximately having to alter all the values yet, it bills for various formatting of the cellular historic past.

Answer 3

In the cell you want to display other info from type = then navigate with your mouse to the cell you want to display, click in it, then hit the enter key.

In the bar above when you click that cell, it will say something like =Sheet3!E17