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.![]()
Bookmarks