+ Reply to Thread
Results 1 to 2 of 2

Conditional Formulas to Another Sheet + Importing Lists

  1. #1
    Registered User
    Join Date
    07-12-2011
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Conditional Formulas to Another Sheet + Importing Lists

    Well I have a few different things I needed some assistance with. I tried my hand at searching, and either came up with inconclusive results or didn't know how to type my question in to google to get an ideal response. I am however selling trading cards, and was looking to set up an excel spreadsheet with my current inventory, trading cost, and ebay costs. Currently my main spreadsheet is something like this

    Card Name - Set it's from - rarity - quantity on hand - trading cost - eBay cost - listed - sold - quantity sold - price received - +shipping - Fees - -Shipping - subtotal.

    Probably a bit overboard on the fields but I had a few different things I was looking to do. Firstly, I want there to be some sort of conditional formatting done (which I couldn't find within excel) to say, "Okay, if you don't have any cards on hand of a quantity, or if you sold a quantity of x card equal to the quantity you originally had, then the name of the card gets a strikethrough."

    Another one of the big things I wanted to do was to write a program in java to take a .csv of my spreadsheet, and use the eBay API to automatically input what the cards were going for on eBay. However I've found a website or two that does that itself. For one of the card brands I started doing this with (Magic The Gathering) there is a list that checks ebay prices daily and updates them, tracking over the last 7 days. The website is : http://magictraders.com/pricelists/current-magic-weekly

    I noticed that I can have Excel import that list (I was going to put it on sheet 3) every time I open my spreadsheet, and I would have really liked a formula that said "If card name from main sheet = card name from sheet 3, price of card name on sheet 3 = eBay cost on sheet 1." I ran into two problems here, firstly, that website has no special pasting. It's just text that isn't seperated whatsoever. I noticed I could separate everything by the commas that are listed, but every time it pulls the data back in, it would overwrite the formatting change.

    Furthermore I have no idea where or how I would implement the formula that would do that. I think those are all the questions I have for now, so please help!
    Last edited by nurse.jason; 07-12-2011 at 10:22 PM.

  2. #2
    Registered User
    Join Date
    07-12-2011
    Location
    New Jersey, US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Conditional formulas and questions

    I don't particularly know what an ideal title would be. As far as I can tell "conditional formulas to another sheet + importing lists" would be as specific as I could get. Because, as stated in my post, I don't know what the correct syntax would even be to search google for help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1