Macro to create check-box + updating reference cells

Hi all,

I have a table set up with the following headings.

Col A | Col B | Col C
"Account #" | "CheckData" | "Checkboxes"


I would like my macro to, whenver activated:
* add the next row to the table
* A new check box will automatically be created in Col C, on the same new row added
* It automatically adjust the references to data cell in Col B, and directly next to the check box cell


Another macro will pick up the T or F in Col B and activate accordingly...


I tried the code to copy a pre-setup check box from the first row of Col C, paste in next row of Col C, but the reference link to data cell would not adjust.

I need some insight guys. Please help.

okay, but my file is huge with lots of other macro, i think it will be difficult to follow. let me try to rig something up in a blank sheet.

So, I would like to click the button and it would,

* add new row to table
* automatically bring a new check box in column C
* set the new check box to output the TRUE or FALSE value in column B, in the cell next to the new check box
* repeats and updates as I press the button

Any insights, please?