I am new to posting and have intermediate excel skills. I have a multiple sheet workbook. I am focused on the “Input” and “Sheet1” sheets. The input sheet is designed so that each row contains all the inputs for that line item. Sheet1 uses the values in the line item to run calculations (i.e. sheet1 row 10 runs all the calculations for input row 6). I would like to set this workbook up so once any information is added to a blank row on the input sheet then sheet1 will drag down a calculation row to calculate the new information (i.e. I add a text / value to input row 11 and sheet1 will drag 6A to 6V down to row 7 to copy the calculations).
Thanks for your help
Thanks for your help