+ Reply to Thread
Results 1 to 1 of 1

Check Boxes with linked cells via format control

  1. #1
    Registered User
    Join Date
    12-03-2010
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2007
    Posts
    11

    Unhappy Check Boxes with linked cells via format control

    I need help with the use of a check box and linking cells via format control. Or maybe I should use a macro???? I am creating a workbook for other users to enter data. This workbook will include 1 worksheet for each day of the month and then a worksheet for tallying some of the input. On the daily worksheets, I have several check boxes which link to the tally worksheet through the format control. I have only created days 1-7 and am wondering if there is a faster way to link the cells then redoing each one individually. I tried to copy and paste the worksheet from 1 day to the next, but it doesn't automatically update the cell link in the control format to the next row on the tally sheet. I have attached a workbook sample. I have highlighted the check boxes, and if you click on the checkbox control and then look at the cell link and follow to the tally worksheet, I think you'll see what I'm trying to do. Any help would be GREATLY APPRECIATED as I'm getting desperate.
    Attached Files Attached Files
    Last edited by DataQueen; 02-24-2011 at 11:59 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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