Code to continue formula in column when adding rows

[Nitefox]

I am currently using the following code to add new rows to my sheet:

Please Login or Register  to view this content.

The code continues the formulas in columns A, B C & F in the newly added rows. I have just recently added formulas in the K column. How can I get it to continue the code in that column also?

Thanks,
James

[FDibbins]

Take a look at using Tables, instead of your code. Tables automatically copy formulas down when you start typing data into a new row

[Nitefox]

The sheet is very complicated and has a lot going on. I tried using tables once and it messed everything up. This has been working great for me, I just need to extend it to work on the K Column also.

[Nitefox]

I just figure out how to get it to copy down the formula in the F column by changing the 6 to 11 on lines 11, 16 and 20 (see bold).

However it now for some reason is also copying the data in column G to all the new rows it adds. How can I keep column G clear in all the newly added rows?

Please Login or Register  to view this content.