Excel VBA

Copper Contributor

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