I have a spreadsheet for ordering my IT equipment.
I have it so when I check a box off it Dashes out the columns to the right of the item this indicates to me that I did not order that item.
My issue is when I had to add a new item into a section I right click and select to add line.. it moves all my columns down and all formulas increment with the exception of my CHECKboxes.
I have to go into VBA and manually increment each line after the line I added... I have a few hundred items so it can get a little tedious updating each line everytime I add an item.
Is there any way to increment checkboxes globally? Or is there a better formula someone can suggest?
I'm attaching a sample of my worksheet with my formula im using.
Please help!![]()
Bookmarks