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
Highlighted

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies