Hello again,
I think it's better to rephrase and go about this one step at a time. I
have Debit account codes in Column E, Credit account codes in Column F,
$values in Column M.

How do you go down the list of Column M and pick each value (skipping
the "" Blanks and zeros) of Column M, extract the Debit account code in
E and the $value in M within that row; paste it to a new tab? Then,
extract the Account code in Column F and the same $value in M; paste it
to the new tab, next row?

Keep looping until no further values in column M.

I'd really appreciate your help.

Thanks so much,
Ricky



*** Sent via Developersdex http://www.developersdex.com ***