LinkBack URL
About LinkBacks
hi guys,
actually i wanna to put check boxes in colums d4:d41 with a formula inside which beginning with this formula (=Sheet1!$D$4) in cell d4.how to copy and drag down this formula into d5:d41?please help...
attendance.xlsm
hi guys,
actually i wanna to put check boxes in colums d4:d41 with a formula inside which beginning with this formula (=Sheet1!$D$4) in cell d4.how to copy and drag down this formula into d5:d41?please help...
attendance.xlsm
You are tying this =Sheet1!$D$4 on which sheet and what is the purpose?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
sheet1.my purpose is to put check boxes in d4:d41 beginning with this formula =Sheet1!$D$4.i dont wanna to type this formula again and again such like =Sheet1!$d$5 and so on, on the cell below d4.how to do the fastest way?
Last edited by pejoi; 11-09-2013 at 05:38 AM. Reason: wrong spelling
Really I am confusedyou are trying to put the reference of the same sheet on the same cell
exactly right!
Ok... That I can give but just let us know what you are trying to achieve? Because we will even suggest you to achieve your goal so easily if you share your rest of the goals.
i wanna to count the total attendance and to create a check box(SELECT ALL)and vice-versa that can select all the checkboxes create in d4:d41.
the main purpose is to create a check box(SELECT ALL)and vice-versa that can select all the checkboxes create in d4:d41.
Ok... after that? what you are going to do? Because I have having an easy alternative method for this one that's why asking more questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks