Hi everyone,
I have been trying to loop through a range of cells and if they have a value different to blank, they should trigger the change of their respective row in another column that contains checkboxes to set their corresponding row value to True. I would require this to be done through the Worksheet Change Event so that every time there is new data input, the formula changes value and then the code gets executed. I have tried everything and now Excel just keeps on restarting every time if I try something new so any help would be greatly appreciated!
I have attached a sample spreadsheet to show what I mean.
Bookmarks