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.
Last edited by DataQueen; 02-24-2011 at 11:59 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1