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.