R
Rightmer
OK…
Let me lead up to the big question.
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/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.
Thank you again for everything!
- Mike Rightmer
- (e-mail address removed)
Let me lead up to the big question.
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/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.
Thank you again for everything!
- Mike Rightmer
- (e-mail address removed)