+ Reply to Thread
Results 1 to 2 of 2

Button to copy specific cells to another sheet, lock button if cell has text

  1. #1
    Registered User
    Join Date
    06-24-2008
    Posts
    10

    Button to copy specific cells to another sheet, lock button if cell has text

    Hi everyone. I am attempting to make an Excel sheet for a role playing game, and I have had very little luck trying to get done one thing that I want.

    I need to be able to record starting values for statistics, which are entered into specific cells. One set of these sets of cells may change down the road, but I'd like to have a record in Excel of what was chosen. I am trying to come up with some way to make a button that will copy the output of a number of cells, into another cell on another sheet. They won't be copying into the exact same cell reference numbers, however. Additionally, I would love to find some way to make the button not function (and give an error message) if a particular cell (the final concatenate cell) has text in it.

    Either that, or a way to use an in-cell formula to copy only the text from a cell the first time it's changed/has data entered into it.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Button to copy specific cells to another sheet, lock button if cell has text

    Layout what you are trying to do in a sample workbook and I think your request should be fairly straight forward.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lock Button that Locks Specific Cells
    By mushman1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2015, 09:35 PM
  2. Copy cell content and paste into another cells in the same sheet using add button
    By Amoursi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2013, 02:28 AM
  3. how lock all of the unlocked cells in a sheet using a button on an other sheet
    By ahmad1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2013, 07:46 AM
  4. Replies: 0
    Last Post: 03-13-2013, 03:14 PM
  5. Protect/Lock specific cells independently through button
    By Edward HS in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-04-2008, 02:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1