Auto copying column formulas to new rows

I'm working on a spreadsheet that tracks project accepted and done over a course of time. I am expecting the data to eventually reach the thousands in a year's time. I have several formulas in specific columns that I need to replicate as the user enters new data into the next row. While it is easy to copy paste the formulas from the cells above, we are looking to save time by having the sheet do this automatically which also prevents the user from accidentally deleting/modifying the said formulas. I am also looking to save file size which is why I am considering doing this in VB. An example of a formula that I need to move down into the next column is:

=IF(ISERROR(VLOOKUP(C2,Tables!A:B,2,FALSE)),"",VLOOKUP(C2,Tables!A:B,2,FALSE))

I am new to VB but would like to gain some understanding on how this works.

Thanks!!!

Lets say your data is in column a, to put a formula in every cell in column b (where the adjacent cell in column a contains a value) you would might use:

Please Login or Register  to view this content.

The formula would have to be in the R1C1 format- so look that up.

Regards
Strud

Thanks Strud! I'll try it out!