trying with out quotes... If-Then problem

[Rightmer]

Sorry,
this is a repost from about ten minutes ago. I made the
mistake of using quotes. Lets try again.


I sell items on ebay. I have learned how to create a few
spreadsheets, and am using my new found knowledge to
create logs of items I am selling or have sold. I have two
sheets in my book that I am trying to link together in a
way.

If I list an item on ebay, and it does not sale, is there
a way to have a cell realize this, and automatically take
the name of this item, and put it into the next blank cell
in the column, so I’ll know to relist it?

I have TONKA TRUCK in cell B2 on sheet one, and to the
right, I have two other column, one labeled LISTING COSTS
and the second labeled TOTAL PROFIT. I have it set up
so that if the amount in LISTING COSTS is more than the
amount in TOTAL PROFIT , than the column TOTAL PROFIT
will show a negative number (ex. 2.00) in the appropriate
cell. I guess what I want to have is some sort of IF -
THEN type thing going.

If the total for TOTAL PROFIT is less than LISTING COSTS,
I want the title TONKA TRUCK to be magically inserted into
the next sheet (sheet two) in the column RELIST ME column
B. Is this possible? Does any of this make sense? Please
help me if you can.

Thanks in advance for everything!

Mike Rightmer
(e-mail address removed)

 

[Andy Brown]

I sell items on ebay.

Sorry, I don't know. But if you could help me, that would be really cool.

I would LOVE to get hold of a copy of Crossroads (with Ralph Macchio, not
that Britney drivel), preferably on DVD.

Is there a way I can set it up so that I get alerted when items matching a
vague description go up for sale?

TIA,
Andy