Insert Row based on cell Value VBA

[jb1994]

Hi,

I am looking to Automatically add a row based on the value in column 'U' - I have a countif formula set up based on Column 'T' being populated with a name, when a name is inputted into column 'T' column 'U' counts and i would like it to trigger a new row being inputted.

i would like this to automatically happen so when the value changes a new row appears without having to manually run the macro.

I have tried a few codes now and not getting any further, my skill set is quite limited.

Any help would be appreciated!

Cheers

 

[jb1994]

Hi,

I am looking to Automatically add a row based on the value in column 'U' - I have a countif formula set up based on Column 'T' being populated with a name, when a name is inputted into column 'T' column 'U' counts and i would like it to trigger a new row being inputted.

i would like this to automatically happen so when the value changes a new row appears without having to manually run the macro.

I have tried a few codes now and not getting any further, my skill set is quite limited.

Any help would be appreciated!

Cheers

i would also need to new row to include the formula's, Data validation and formatting of the row above.

 

[mumps]

It is hard to work with a picture. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet including the formula you are using in column U. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).