filling cell in column "a" if data present in column "b" issue.

hello,
i am working on a spreadsheet for work and one of the tasks I'm trying to accomplish is when i fillout a cell in the "Part #" column(B) to auto fill the equivalent cell in the "CUST #" Column(m) with the number 808849. i have this working except it over rights my header row(row 7) because the label "PART #" means that cell is filled so it overrights "CUST #". i have tried to limit the range to row 8+ but it then freaks out and dumps 808849 into a bunch of random fields. in the attached file i had to sanitize it due to confidentiality. if it would help i can fill it back up with fake info. i know everyone says this but i am pretty new to VBA scripting so i'm sure I'm missing something very obvious, also i know this script is a bit useless by itself but it's only step one to a much larger intent.

Please Login or Register  to view this content.

Blank_template.xlsm

Hi Tim

I cannot see where you are controlling your macro.

This is your basic problem. Insert the following line.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Could this be of help?

Please Login or Register  to view this content.

thanks for the help this solved my problem completely