sorry if my comments where not clear earlier. I want the macro check if a account number entry already exists in the data sheet with the entity and account definition combination listed in the account definition model selected by user (in J1 cell) and if it doesn't exist only then include the same in the data worksheet and highlight that added entry in yellow.