+ Reply to Thread
Results 1 to 2 of 2

Copy row that contains check boxes without the check boxes being linked

  1. #1
    Registered User
    Join Date
    04-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    83

    Copy row that contains check boxes without the check boxes being linked

    I am working on a form that has 150 lines with address and then a check box in the row to indicate that something has been done. I have linked that to another cell so that I get a true false. I will then be setting it up to count the true false so that it will keep counts for me. The problem that I am having is when I copy the row down all the check boxes in the column are linked. I check one and the rest become checked. I don't want to have to individual add check boxes in for each 150 lines.

    I have attached a sample of what I am trying to do. DCVA install.xlsx

    Thanks - Frank

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copy row that contains check boxes without the check boxes being linked

    It is a "one at a time" job as the cell references in the properties will accept a relative reference but will not change when copied and pasted. I also noticed that you might want to change the formulae in J12 to M12 to count "True" instead of "False" if you want to count each selected checkbox because the false is the unselected state and as it now stands all unselected checkboxes are being counted.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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