I have a table with names against codes, with amounts for each entry. I
want to display each entry that is more than 0 in another report table.
i.e.
code a code b code c
andy 4 2 7
bob 0 0 1
martin 2 0 0
So here, i want to go through each column and put the name,the code and
the amount in another three cells, as long as the amount is more than
zero.
Thanks
Andy
--
Andyd74
------------------------------------------------------------------------
Andyd74's Profile:
http://www.excelforum.com/member.php...o&userid=34013
View this thread:
http://www.excelforum.com/showthread...hreadid=546715