I have the following table:
A B
1 Adam -50
2 James MET
3 Hank -800
4 Will -300
5 Bill MET
6 Ken -98
7 Frank -80
8 Kerry -220
9 Ken -400
10 Bond MET
There are these 10 guys which either met their payments or still owe
certain amount. The status column B can either have a negative numbe
in it or the word MET. So all guys could either have met the deadlin
to pay or still owe. I wanted to have shown on another page in 2 colum
shown like this:
A B
1 GOOD BAD
2 James Adam
3 Bill Hank
4 Bond WIll
5 Ken
6 Frank
7 Kerry
8 Ken
9
10
I just don't know what macro or something else would work that can loo
at the first table and then list the people in the right columns, Goo
and Bad on the first page.
Thanks, I appreciate the help
--
Message posted from
http://www.ExcelForum.com