Copy information from one cell to another based on drop down selection

%3CLINGO-SUB%20id%3D%22lingo-sub-3099718%22%20slang%3D%22en-US%22%3ECopy%20information%20from%20one%20cell%20to%20another%20based%20on%20drop%20down%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099718%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20some%20issues%20figuring%20this%20out%20for%20some%20reason.%20So%20everyone%20has%20a%20better%20idea%20of%20what%20I'm%20trying%20to%20do%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20inside%20of%20my%20sheet%2C%20whenever%20the%20dropdown%20selection%20%22DEPLOYED%22%20is%20chosen%20in%20the%20%22STATUS%22%20Column%2C%20I%20want%20to%20copy%20the%20information%20in%20one%20column%20and%20move%20it%20to%20another.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eex.%20%22STATUS%22%20Column%20is%20Column%20C%20where%20you%20select%20from%20a%20list%20of%20options.%20When%20%22DEPLOYED%22%20is%20selected%20I%20need%20to%20copy%20the%20data%20from%20Column%20A%20in%20its%20respected%20row%20and%20paste%20that%20same%20information%20into%20Column%20M%20of%20that%20same%20row.%20So%20if%20under%20C50%20%22DEPLOYED%22%20is%20selected%20from%20the%20dropdown%2C%20it%20will%20automatically%20move%20the%20information%20from%20A50%20to%20M50.%20The%20rule%20also%20needs%20to%20apply%20to%20the%20entire%20table%20(Columns%20A%20-%26gt%3B%20M%2C%20Rows%20%23%20%3D%20661).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3099718%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099978%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20information%20from%20one%20cell%20to%20another%20based%20on%20drop%20down%20selection%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099978%22%20slang%3D%22en-US%22%3EHi%20Simply%2C%20just%20add%20a%20formula%20on%20M%20column%20to%20check%20if%20the%20C%20cell%20value%20is%20%22DEPLOYED%22%20then%20refer%20to%20it%2C%20otherwise%20leave%20the%20cell%20empty.%20copy%20this%20formula%20into%20M50%20%3DIF(C50%3D%22DEPLOYED%22%2CA50%2C%22%22)%3C%2FLINGO-BODY%3E
Occasional Visitor

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!

1 Reply
Hi Simply, just add a formula on M column to check if the C cell value is "DEPLOYED" then refer to it, otherwise leave the cell empty. copy this formula into M50 =IF(C50="DEPLOYED",A50,"")