Cell Population

[ctrapper]

Sorry wasn't sure how to word the subject line: I have a bunch of calculations to do, and trying to find a shortcut. I basically have a column of numbers in Column I. These #'s are used as a base # for a forumla. The base # is in M2. So right now I go Row by Row, and if I need the # from Column I, I manually enter it into M2. Is there a way to change the cell in M2 to whatever I click to in Column I? Example, say I18 has 100 in it, I need 100 in M2, is there a way to click I18, and have it populate to M2? I would want to be able to do this all the way down column I when I need it. Thanks in advance for any help.

[ChemistB]

This event macro which should be pasted inside your worksheet should do the trick. When you doubleclick on a cell in I, that value will appear in M2.
To copy this code into your workbook, right click on the appropriate worksheet tab and "View Code". Then paste the code in.

Please Login or Register  to view this content.

Does that work for you?

[ctrapper]

Great.. let me try it.. I have not messed with Code much.. but let try.

[ctrapper]

Chemist, works great.. but I need one adjustment.. I apologize, I left out Column H, I see you referred to column I as 9 in the code. So would I recopy your previous Code and change the 9 to an 8? Or modify the one you gave me? Sorry, I was rushing earlier. So basically I go row by row, and need to either take the value from column H or I, and need to double click it.

[ctrapper]

Oh! I got it.. I just changed your code to read If Target.Column = 8 or 9! Awesome.. thanks a ton.. BIG time saver for me.. mark me as solved!

[ChemistB]

mark me as solved

Sorry, you need to do that yourself. Go to your first post and click on "Edit" and then go advanced and change the prefix. Glad I could help.