Quote:
Originally Posted by wheddingsjr
I will still have to make the deductions over 12 manually, but at least I do not have to go through all 30k lines manually.
|
Simply add another column, where you enter the formula (I havent Excel at moment, and I don't remember ecact column headings)
NewQty = OldQty + Correction
If I remember correctly, the correction was negative.