Home

Creating a Form

%3CLINGO-SUB%20id%3D%22lingo-sub-842302%22%20slang%3D%22en-US%22%3ECreating%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842302%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20set%20up%20that%20has%20a%20drop%20down%20list%20referencing%20different%20rows%20in%20another%20tab.%20Say%20the%20list%20is%20referencing%20row%204%2C%20I%20need%20the%20cells%20below%20it%20to%20automatically%20change%20to%20show%20row%204.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EFor%20example%2C%20C1%20is%20referring%20to%20Row%202%20on%20a%20different%20sheet%20and%20C3%20is%20being%20pulled%20from%20cell%20DO2%20on%20the%20other%20sheet.%20When%20C1%20changes%20to%20refer%20to%20a%20different%20row%20(i.e.%20row%204)%2C%20I%20need%20C3%20to%20automatically%20adjust%20and%20refer%20to%20cell%20DO4%20on%20the%20other%20sheet.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130580iDBDC04773ACB0562%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%221.png%22%20title%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20trickier%20part%20of%20this%20is%20that%20if%20someone%20were%20to%20enter%20%2430%2C000%20into%20C4%20in%20the%20image%20above%2C%20I%20need%20it%20to%20automatically%20update%20cell%20DP2%20in%20the%20other%20sheet%20to%20reflect%20%2430%2C000.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842399%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295182%22%20target%3D%22_blank%22%3E%40ineedhelp%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20the%20same%20question%20as%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FFormula-help-Drop-down-list%2Fm-p%2F842387%2Fhighlight%2Ffalse%23M39577%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FFormula-help-Drop-down-list%2Fm-p%2F842387%2Fhighlight%2Ffalse%23M39577%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842401%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYes%2C%20same%20question.%20Just%20trying%20to%20get%20it%20figured%20out%3C%2FP%3E%3C%2FLINGO-BODY%3E
ineedhelp
Occasional Contributor

I have a table set up that has a drop down list referencing different rows in another tab. Say the list is referencing row 4, I need the cells below it to automatically change to show row 4.

 

  1. For example, C1 is referring to Row 2 on a different sheet and C3 is being pulled from cell DO2 on the other sheet. When C1 changes to refer to a different row (i.e. row 4), I need C3 to automatically adjust and refer to cell DO4 on the other sheet.

1.png

 

The trickier part of this is that if someone were to enter $30,000 into C4 in the image above, I need it to automatically update cell DP2 in the other sheet to reflect $30,000.

 

Any help is greatly appreciated.

2 Replies

@Sergei Baklan Yes, same question. Just trying to get it figured out

Related Conversations