Excel VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1427225%22%20slang%3D%22en-US%22%3EExcel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1427225%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20I%20am%20trying%20to%20find%20a%20way%20in%20which%20when%20I%20make%20an%20adjustment%20in%20a%20cell%2C%20that%20it%20takes%20that%20difference%20and%20automatically%20places%20the%20difference%20in%20another%20cell%20within%20the%20same%20sheet%20and%20includes%20the%20name.%26nbsp%3B%20So%20for%20example%20if%20I%20make%20a%20change%20in%20the%20count%20in%20cell%20L%205%20from%2043%20to%2050%2C%20the%20difference%20of%207%20is%20what%20I%20want%20to%20move%20to%20cell%20B%2019%20and%20to%20automatically%20bring%20over%20the%20name%20of%20the%20Unit%20from%20cell%20K%205%20to%20cell%20A%2019%20because%20of%20the%20change%20in%20counts.%26nbsp%3B%20Then%20I%20want%20to%20ensure%20that%20it%20will%20work%20for%20all%20information%20in%20columns%20K%2CL%2CM%20and%20N%20to%20move%20over%20to%20rows%2019%2C20%2C21%2C22%2C23%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F195406i4082437F80CBB966%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1427225%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%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Hello,

    I am trying to find a way in which when I make an adjustment in a cell, that it takes that difference and automatically places the difference in another cell within the same sheet and includes the name.  So for example if I make a change in the count in cell L 5 from 43 to 50, the difference of 7 is what I want to move to cell B 19 and to automatically bring over the name of the Unit from cell K 5 to cell A 19 because of the change in counts.  Then I want to ensure that it will work for all information in columns K,L,M and N to move over to rows 19,20,21,22,23Capture.JPG 

0 Replies