Create insertion cell

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3173651%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3ECreate%20insertion%20cell%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3173651%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EGreetings%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Enot%20sure%20if%20what%20i%20will%20be%20sharing%20has%20been%20discussed%20before%20or%20not%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ehopefully%20someone%20will%20be%20able%20to%20help%20me%20with%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ei%20am%20trying%20to%20create%20an%20excel%20file%20as%20data%20entry%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20create%20two%20sheets%20in%20this%20file%20let's%20call%20the%20first%20Amount%20%2C%20the%20second%20is%20Detailed%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ethe%20first%20(Amount)%20should%20have%20only%20one%20cell%20that%20i%20need%20to%20write%20down%20the%20data%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ethe%20second%20(Detailed)%20should%20have%20multiple%20cells%20%2C%20and%20each%20cell%20should%20read%20from%20the%20cell%20in%20the%20(Amount)%20and%20after%20the%20data%20has%20been%20read%20by%20cells%20%2C%20automatically%20it%20will%20move%20the%20next%20cell%20in%20the%20(Detailed)%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3Ehow%20that%20might%20be%20possible%20to%20be%20done%20knowing%20the%20Excel%20has%20a%20limitless%20abilities%20to%20create%20functions%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20guys%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3173651%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EDeveloper%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3173651%22%20slang%3D%22en-US%22%3ECreate%20insertion%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3173651%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3Enot%20sure%20if%20what%20i%20will%20be%20sharing%20has%20been%20discussed%20before%20or%20not%3C%2FP%3E%3CP%3Ehopefully%20someone%20will%20be%20able%20to%20help%20me%20with%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20trying%20to%20create%20an%20excel%20file%20as%20data%20entry%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20create%20two%20sheets%20in%20this%20file%20let's%20call%20the%20first%20Amount%20%2C%20the%20second%20is%20Detailed%3C%2FP%3E%3CP%3Ethe%20first%20(Amount)%20should%20have%20only%20one%20cell%20that%20i%20need%20to%20write%20down%20the%20data%3C%2FP%3E%3CP%3Ethe%20second%20(Detailed)%20should%20have%20multiple%20cells%20%2C%20and%20each%20cell%20should%20read%20from%20the%20cell%20in%20the%20(Amount)%20and%20after%20the%20data%20has%20been%20read%20by%20cells%20%2C%20automatically%20it%20will%20move%20the%20next%20cell%20in%20the%20(Detailed)%3C%2FP%3E%3CP%3Ehow%20that%20might%20be%20possible%20to%20be%20done%20knowing%20the%20Excel%20has%20a%20limitless%20abilities%20to%20create%20functions%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20guys%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3173651%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Greetings,

not sure if what i will be sharing has been discussed before or not

hopefully someone will be able to help me with 

i am trying to create an excel file as data entry

My goal is to create two sheets in this file let's call the first Amount , the second is Detailed

the first (Amount) should have only one cell that i need to write down the data

the second (Detailed) should have multiple cells , and each cell should read from the cell in the (Amount) and after the data has been read by cells , automatically it will move the next cell in the (Detailed)

how that might be possible to be done knowing the Excel has a limitless abilities to create functions 

Thanks guys

0 Replies