Results 1 to 4 of 4
  1. #1
    Full Member bobby131313's Avatar
    Join Date
    November 12th, 2007
    Location
    Dover, DE
    Posts
    550
    Cool Excel Formula for eBay Affiliates
    I posted this in another thread but I think it's worthy of it's own.

    Most of you know that you can download an Excel spreadsheet of your eBay sales through CJ. Most of you also know that the OID cell contains the auction number.

    How many of you sit there with the high ones double clicking the cell, plucking out the auction number, and going to eBay to see what it was? Can't resist, I know.

    How cool would it be to just have a clickable link right in the spreadsheet for each item?

    Code:
    =HYPERLINK(CONCATENATE("http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=",MID(P28,((SEARCH(";",P28,1))+1),((SEARCH(";",P28,((SEARCH(";",P28,1))+1)))-(SEARCH(";",P28,1))-1))), "Show Me The Money!")
    Take that code, paste it in row 2 of the first new column, then copy that cell all the way down the column. Voila.

  2. #2
    Chick with Brains Tracy's Avatar
    Join Date
    January 18th, 2005
    Location
    Polk County, Florida
    Posts
    1,878
    There is in a error in your formula. You say to place it in Row 2 of the last Column (which would be Column T); however, you have hard coded P28 as the reference cell. If you place the formula in that cell it's going to pull the auction for Row 28. Copying it to the next row will produce the results for Row 29, and so on.

    You need to correct your code to replace all the P28's with P2 for your formula to work as you intend it to.

    Here's the formula I've always used:

    Code:
    ="http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item="&MID(P2,FIND(";",P2)+1,12)
    It Also needs to be placed in Cell T2; however, it doesn't create an automatic hyperlink. I just place my cursor in the cell, and press copy (CTRL-C) and paste it into a browser. This way, I just use the same browser window instead of having a new window open for each auction.
    Last edited by Tracy; December 6th, 2007 at 03:58 PM.

  3. #3
    Full Member bobby131313's Avatar
    Join Date
    November 12th, 2007
    Location
    Dover, DE
    Posts
    550
    I don't where those 8's came from. When I use my macro it adds it perfectly. Thanks Tracy.

    Here it is corrected....

    Code:
    =HYPERLINK(CONCATENATE("http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=",MID(P2,((SEARCH(";",P2,1))+1),((SEARCH(";",P2,((SEARCH(";",P2,1))+1)))-(SEARCH(";",P2,1))-1))), "Show Me The Money!")

  4. #4
    Full Member GoColts's Avatar
    Join Date
    December 2nd, 2007
    Location
    Indianapolis, IN
    Posts
    380
    Quote Originally Posted by bobby131313
    I don't where those 8's came from. When I use my macro it adds it perfectly. Thanks Tracy.

    Here it is corrected....

    Code:
    =HYPERLINK(CONCATENATE("http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=",MID(P2,((SEARCH(";",P2,1))+1),((SEARCH(";",P2,((SEARCH(";",P2,1))+1)))-(SEARCH(";",P2,1))-1))), "Show Me The Money!")
    Great formula! Thanks for sharing that.

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Replies: 0
    Last Post: April 29th, 2011, 12:31 PM
  2. ALL Ebay Affiliates...
    By ClayBillionaire in forum Commission Junction - CJ
    Replies: 35
    Last Post: December 3rd, 2007, 11:49 PM
  3. Cool Conferences for Affiliates?
    By blakekri in forum Midnight Cafe'
    Replies: 8
    Last Post: May 18th, 2007, 06:14 PM
  4. Ebay Affiliates?
    By wireninja in forum Other Affiliate Networks
    Replies: 17
    Last Post: March 7th, 2007, 02:00 PM
  5. EBay Affiliates?
    By Fandango in forum Canadian Affiliates
    Replies: 0
    Last Post: May 14th, 2004, 03:13 PM

Posting Permissions

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