Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to make a an excel cell copy from another cell in the same document but different page at a click of a button. I want it to copy a name from another cell not a number

share|improve this question
Do you actually want it to wait for you to click something, or is the default behaviour of updating automatically sufficient? – Paul Apr 20 '12 at 10:47

For the 'click of a button' part you'd need to use VBA. Simple exmaple:

  1. Create a new spreadsheet

  2. Press Alt-F11 to get the VBA editor up

  3. Double-click the ThisWorkbook entry in the VBAProject tree on the left; this should give you a blank editor

  4. Paste in the code at the bottom of this post

  5. Make sure the Developer tab is turned on; instructions here

  6. Add a button; instructions here

Code for point (4) above: note that this copies from cell B1 to cell A1. You can replace those with any cell values, of course, but also with a name rather than a cell address. For example, if you have a named cell of "MyVal", you'd put "MyVal" in the place of "B1" or "A1".

Sub CopyValue()
    ActiveSheet.Range("A1").Value = ActiveSheet.Range("B1")
End Sub
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.