The workbook consists of a list of items sometimes 50 items long.Column 1 - Gross per itemColumns 2 to 9 - Various expensesColumn 10 - Nett per item I can easily calculate the nett using formula :Column 1 minus Sum(2:9)But this is a lengthy process doing each row individually.How can I apply this argument to the whole workbook?Thanks in advance.How can I apply this argument to the whole workbook
Do the first one in column 10 by hand and press enter. put the mouse on that cell with the pointer on the bottom right hand corner press the left mouse button and drag it down as far as you want to go.
Many thanks my friend!
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.