Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.