Program so that clicking on a cell will copy that cell to another

[Josh Johansen]

I have a list of the next six mondays that I allow a user to see and I want
them to be able to click on any of those 6 cells to display that date into a
different cell that I am using for calculations. As it is now I have them
typing in the date manually by using the 6 listed mondays before to make sure
they choose a monday. How can I generate a hyperlink or command button so
that when they click on the monday they want, it is automatically inserted
into the cell. Thank you.

 

[Vasant Nanavati]

Would Data Validation work for you?
________________________________________________________________________

 

[Josh Johansen]

I am not too familiar with VBA, what is Data Validation? Basically what I
have made is a short list of the next 6 mondays so users could see what they
were without having to look at a calander (they enter a monday to see the
next week of scheduled work) and I thought it might be easier if I could just
create a link so that when they click on the cell containing the monday they
want that it would copy that date to the cell they are now typing the date
in. I hope this helps explain, thanks!

 

[Vasant Nanavati]

I really think Data Validation is the better approach here (no VBA
required!). With the target cell (the one in which the date woulld be typed)
active, go to the menu and use the following sequence:

Data | Validation | Allow: List | Source: (enter the range with the 6
Mondays) | OK.

Now when the user clicks on the dropdown arrow, he/she will be able to
select one of the Mondays in your list.
_______________________________________________________________________

 

[Josh Johansen]

Awesome! Thanks so much!

I really think Data Validation is the better approach here (no VBA
required!). With the target cell (the one in which the date woulld be typed)
active, go to the menu and use the following sequence:

Data | Validation | Allow: List | Source: (enter the range with the 6
Mondays) | OK.

Now when the user clicks on the dropdown arrow, he/she will be able to
select one of the Mondays in your list.
_______________________________________________________________________