Mirror selected cell in another

**heidenman** · 07-28-2009, 10:10 AM

I need help!

I would like to instantly mirror any selected cell within a specific column into another specified cell.

Example:
If A1 has the value 4, A2 has the value 6, A3 has 7, A4 has 9, and I click on those cells in the order above, I would like to see the cell I specify show the same value when I've selected (clicked on) them.

Heeelp!!

Thanx in advance..

**Phil_V** · 07-28-2009, 10:16 AM

So for example, you click A1 and C1 will become 4, you click A2 and cell C1 will become 6, A3 and C1 will become 7, A4 and C1 will become 9?

If so, something like this in the 'Sheet' code will do it:

Please Login or Register  to view this content.

Where the RED area is where you have your values, and the BLUE area is where you want the value changed.

**heidenman** · 07-28-2009, 10:25 AM

Thats just beautiful!

My first post, answered within minutes, works perfectly!

Thanks!

Man I love this forum stuff.

Now all I need is a book on VBA excel. Or that is, do I?

Hehe.

Thanks again.

**Phil_V** · 07-28-2009, 10:38 AM

No problem, don't forget to mark your thread as solved though.
Edit the first post, click [Go Advanced] and then use the dropdown in front of the subject to select 'Solved'. Thanks

**thecdnmole** · 08-22-2009, 10:38 AM

This works for one cell, how do I change the macro so that the the same reference cells can be used in many empty cells. For example, cells A1:A10 are blank and cells C1:C10 have the data I want to select from. I want to select cell A1, choose from the values in column C, then go to cell A2 and again select from column C and so on. Thanks!