If I have a worksheet with a range of cells (ex. A1:G10) containing dates, is there any way I can setup the worksheet to return the value whatever cell I click on (one click or double click) to another specified cell? Example: Say I've designated F1 to be the cell I want the selected value to return to. I click on cell A1 (which contains 1/1/2010) it will return that value to cell F1.
Is this possible? I'm imagining something similar to a "little hand" selection icon.
Also, if so, can this be done without using macros. And if not, will the macro be usable in both excel 2003 and 2007?
Is this possible? I'm imagining something similar to a "little hand" selection icon.
Also, if so, can this be done without using macros. And if not, will the macro be usable in both excel 2003 and 2007?