Macro to insert a value in a cell when the same cell in a different column=specific value

[sdtgilbert]

I need a macro to insert a value in a cell when the same cell in a different column equals a specific value.

When any cell in column "W" equals "101714", I need same cell in column F to equal "776/377".

I'm sure it's an easy solution but I am new at this and don't know the best way. I would like to add it to the existing Macro I created for this project.

Thanks,
sdtgilbert

confused:

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[sdtgilbert]

Thank you John. It worked perfectly!!!

[JOHN H. DAVIS]

You're welcome. Glad to help out, and thanks for the feedback.