Dear Fellows,
I have a lot of my stamps listed in MS Excel and want to do some fairly
advanced data base manipulations on them such as sorting on specific
criteria, generating want lists, general organization etc. I know there are
lots of stamp data
base programs out there, but since I already have a few thousand entered
with descriptions, page # and CV (and lots of other stuff) it would be way
to much effort to transport them to another program. What I'm looking for
is someone who is familiar with logical operators in macros. I have pretty
much all the function knowledge I need, but the logical macro manipulation
needs help.

Here is what I want to do first (extremely simplified).... Say in an Excel
sheet you have 2 columns of values (the column to the left is the cat #, and
the column on the right is something like a U or a M, or it could be a
dollar value, what ever). I want to go down the left column and check each
cell to the right of that cell to see if it is occupied by a value,
number..what ever. If the cell to the right is blank (like ISNUM, false)
then take the left cell's text/value and paste it to another location which
constitutes a list. As the check continues down the left column, the list
grows. Of course this is a dynamic list as every time you run the macro the
list potentially changes. I know this can be done, I have seen it. Can
you help me???
Thanks
Wolf-==-