Results 1 to 13 of 13

Need Advice on how to Increment ALL checkboxes at once or a better formula for my project

Threaded View

Kapi187 Need Advice on how to... 03-12-2013, 02:04 PM
cytop Re: Need Advice on how to... 03-12-2013, 02:36 PM
Kapi187 Re: Need Advice on how to... 03-12-2013, 04:18 PM
cytop Re: Need Advice on how to... 03-12-2013, 04:56 PM
Kapi187 Re: Need Advice on how to... 03-12-2013, 05:12 PM
cytop Re: Need Advice on how to... 03-12-2013, 05:27 PM
Kapi187 Re: Need Advice on how to... 03-12-2013, 05:56 PM
cytop Re: Need Advice on how to... 03-12-2013, 05:58 PM
Kapi187 Re: Need Advice on how to... 03-13-2013, 12:10 PM
cytop Re: Need Advice on how to... 03-13-2013, 12:18 PM
Kapi187 Re: Need Advice on how to... 03-14-2013, 04:43 PM
cytop Re: Need Advice on how to... 03-14-2013, 04:57 PM
Kapi187 Re: Need Advice on how to... 03-18-2013, 05:18 PM
  1. #1
    Registered User
    Join Date
    04-29-2009
    Location
    New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    15

    Need Advice on how to Increment ALL checkboxes at once or a better formula for my project

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1