cycle through list and put data found in col a into col d
You can do it without a macro...
Add this formula to cell D2 and copy down...
=IF(SUM(B2:C2)=0, A2,D3)
If you need to remove the reference lines that can be done...
--
HTH...
Jim Thomlinson
"april" wrote:
sorry about the confusing subject title.
col a col b col c col d
account # debit
account # credit
journal reference
i want the journal reference to appear in col d rows 1 and 2. currently,
col d is empty. the rows do not always follow the pattern row 1 debit, row 2
credit. you can have 4 rows of debit and one row of credit
thank you in advance for your help.
--
aprilshowers
|