+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Use of Checkbox and cell links

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

    Unhappy Use of Checkbox and cell links

    Your help is appreciated!!
    Have attached a workbook sample. I am creating a workbook for 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. 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. This probably is clear as mud but take a look at the workbook - 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 appreciate as I have many other projects to work on.
    Attached Files Attached Files
    Last edited by DataQueen; 02-17-2011 at 03:32 PM. Reason: No responses...

+ 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