using IF - THEN values on seperate sheets

[Rightmer]

Ok here is one for you.

I posted this on another group, with no success. If you
can help PLEASE respond.


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)

 

[Bernie Deitrick]

Mike,

You would need to use a macro that looks at the appropriate values and
moves the values based on your criteria.

For us to help you, you'll need to explain this a little better:

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.

Your listing cost is one column, your total profit is another, so then
your negative number must show up in a third column.

HTH,
Bernie
MS Excel MVP

 

[Otto Moehrbach]

Mike
A macro is what you need. You can automate it to happen whenever a
cell in that column goes negative or you can manually trigger the macro with
a button on the sheet. Which do you want?
If you wish, send me a sample of your file and I'll set it up for you.
Remove "cobia97" from my email address. HTH Otto