I'm having some issues figuring this out for some reason. So everyone has a better idea of what I'm trying to do:
Basically inside of my sheet, whenever the dropdown selection "DEPLOYED" is chosen in the "STATUS" Column, I want to copy the information in one column and move it to another.
ex. "STATUS" Column is Column C where you select from a list of options. When "DEPLOYED" is selected I need to copy the data from Column A in its respected row and paste that same information into Column M of that same row. So if under C50 "DEPLOYED" is selected from the dropdown, it will automatically move the information from A50 to M50. The rule also needs to apply to the entire table (Columns A -> M, Rows # = 661).
Any help would be greatly appreciated!