Automatically copy down formulas when data entered in new row

[elabamnoj]

I have a shared spreadsheet for tracking recruitment and have separate columns with formulas in them. I would like a macro that automatically copies down formulas when I have a user input data in the last empty row of column A e.g. a coworker enters enters data into A:56 and formulas from corresponding columns T, Y, Z, AM etc are copied onto the same row. I know this is possible with a table, but I want to avoid coworkers sorting the table and putting things out of sequence, as we have processes outside of Excel that requires me to quickly see the latest data input towards the bottom without having to wonder if someone sorted the table without me knowing.

[vichopalacios]

Hi elabamnoj

You can use this two codes in the correponding sheet's module
But first you need to declare a Public variable

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[elabamnoj]

Thank you! It works great. Unfortunately I have to comment out another macro already in the sheet's module when I tested it to work. The other macro clears a dependent drop-down list when the primary drop-down is changed.

I get this error when I uncomment the top macro.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[vichopalacios]

Perhaps because you cannot have two subs with the same name

Please Login or Register  to view this content.

Try to combine both procedures inside the same sub.

[elabamnoj]

Okay, I tried to combine it in several combinations. The best result is no error, but my original macro to clear dependent drop-downs still does not work. I will post this onto a new thread. Thank you very much vichopalacios for your help.