Good day.
Please help me to have checkbox on second pages checked automatically, when check box on page 1 is checked.
Good day.
Please help me to have checkbox on second pages checked automatically, when check box on page 1 is checked.
On the first sheet right click on one of the check boxes and select "Format Control". In the "Cell Link:" box enter a cell reference of an area of the sheet you're not using and can be hidden away. Q1 for example.
Then go to the second sheet and do the same but rather than just putting Q1 in the cell link box you need to put sheet name and cell reference. So it will look like 'Requisition from Unit'!Q1 (Note because your sheet name has spaces you will need to wrap the sheet name in single quotes).
Repeat the above for all the checkboxes, using a difference cell for each, and now they will be linked and will match each other regardless of which sheet you change the tick box status on.
BSB
Thank You so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks