Happy New Year to you.
I am maintaining a master file which keeps track of all the applications submitted to me. This file is being updated by copying data from an excel application form (submitted by user) and then transpose and pasted into row.
I have done conditional formatting on column H (which is the company name) to spot duplicate submission but it seems like when i transpose paste, the conditional formatting is overridden. I have done a macro to refresh and redo the conditional formatting but it is too tedious to refresh everything i update the master file.
Can this be resolved by VBA please?
Thank you.
I am maintaining a master file which keeps track of all the applications submitted to me. This file is being updated by copying data from an excel application form (submitted by user) and then transpose and pasted into row.
I have done conditional formatting on column H (which is the company name) to spot duplicate submission but it seems like when i transpose paste, the conditional formatting is overridden. I have done a macro to refresh and redo the conditional formatting but it is too tedious to refresh everything i update the master file.
Can this be resolved by VBA please?
Thank you.