I am working with a very large table with a range of $B$7:$G$16006 (with the headers in row 6) that is updated dynamically through sheet formulas.
My issue is related with inserting a checkbox (Form control type) next to each row in cell $A7 if the formula in column C (second column in my table) does not result in a "" or "0".
The formula I am working with is:
The problem with this is that 1) this takes forever to execute/freezes excel due to the number of table rows to loop through (16000) and 2) I cannot figure out how to incorporate the "LinkedCell" code needed to insert TRUE/FALSE in to the address cell of each checkbox.
I have also been looking at "Marlett checkboxes" however cannot figure out how to create the code to only add the Marlett feature to a cell in column A if the row/cell in column C is not "" or "0":
Suggestion are greatly appreciated, apologies for the long post but I am trying to find the best approach!
Bookmarks