Mirror selected cell in another

**thecdnmole** · 08-22-2009, 11:49 AM

A macro was submitted in a similar thread, but I have a slightly different problem. I have empty cells, A1:A10, and in cells C1:C10 I have data. If A1 is selected, I would like to be able to click on any cell in colum C and that
info then appears in A1. Then I will select A2, and again, click on any cell
in C1:C10 and that appears in A2 and so on. I do not want cells A1 etc. to
change once populated. This can be a macro as well. Thanks!

**Leith Ross** · 08-22-2009, 11:59 AM

Hello thecdnmole,

If the macro were to load A1 first when the user clicked a cell in C1:C10, and then A2 etc. Would this be a problem? From a programming stand point it easier and more direct.

**mrice** · 08-22-2009, 12:06 PM

Try this.

Please Login or Register  to view this content.

It needs to be pasted into the appropriate sheet tab in the VBA editor.

**thecdnmole** · 08-22-2009, 01:10 PM

Originally Posted by Leith Ross

Hello thecdnmole,

If the macro were to load A1 first when the user clicked a cell in C1:C10, and then A2 etc. Would this be a problem? From a programming stand point it easier and more direct.

No, that wouldn't be a problem. What this is is an invoice and staff need to select items from a list of parts to populate the lines. I used a "list", but they found it too long and repetative always having to scroll thru the list looking for an item. If I have the list beside the form, they could just click on the items in the list to populate each row on the invoice. Thanks for the help!!

**thecdnmole** · 08-22-2009, 01:15 PM

Originally Posted by mrice

Try this.

Mrice, that looks like it will work!! Of course I gave a simple example of what I need, so will put that into my spreadsheet today and see how it works, but for now, looks great. THANKS!!

**thecdnmole** · 08-22-2009, 03:19 PM

Macro works good on a blank spreadsheet, but I need a bit more help. The cells I need populated on my invoice are G17:G29 and the source data to click on will be found in cells P1:P50 and T1:T50. I have tried to change the macro to suite, but I am unfamiliar with macro programing and am not having any luck. Would you be so kind to change the macro provided with the cells indicated in this text. Greatly appreciated! Thanks again!!

**mrice** · 08-22-2009, 03:36 PM

Try this version.

Please Login or Register  to view this content.

**thecdnmole** · 08-22-2009, 03:53 PM

mrice;2150472]Try this version.

I gave that a quick try and again, THANKS!! Works AWESONE

. If I have to tweek it, I am hopeing between the two macros I can figure it out. I think my staff will be very happy with this!

**thecdnmole** · 08-22-2009, 06:49 PM

One more request! The invoice is off the screen when selecting from the parts list. I would like to merge 4 cells and have a countdown number in that cell. It would start off at 14 and count down as items are selected, otherwise they may get click happy and run out of room on the invoice. Okay, I am going all out here, would it be possible to make this "countdown box" move with the sheet, so it's always visible? Thanks!