Hi all -
I've found a number of similar queries, but nothing that does exactly what I think I need (unless I just don't know the terms, which is possible). Anyway, I have a list of fixed assets and I need a user to enter a term and see if that asset already exists. I.e. let's say I want to...
So, I've got a basic pivot chart tied to a pivot table with some data in it (in this case, project revenue and cost). I have a drop down on the pivot table with the project in it (i.e. Project 1, project 2, etc.). When I filter the pivot table on Project X, the data in the pivot chart should...
I think this is VERY simple, but can't seem to figure it out.
Let's say I have 40 cells with various values in them.
In another cell on the same sheet, I want to return the value of whatever cell is selected.
Ex. I put my cursor on cell B3, and in B3 it says "JACK" - in a designated...