Results 1 to 4 of 4
December 6th, 2007, 09:32 AM #1Cool 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?
=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!")
December 6th, 2007, 02:28 PM #2
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:
Last edited by Tracy; December 6th, 2007 at 02:58 PM.
December 7th, 2007, 08:16 AM #3
I don't where those 8's came from. When I use my macro it adds it perfectly. Thanks Tracy.
Here it is corrected....
=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!")
December 11th, 2007, 02:23 PM #4Originally Posted by bobby131313
By GoColts in forum eBay Partner NetworkReplies: 0Last Post: April 29th, 2011, 11:31 AM
By ClayBillionaire in forum Commission Junction - CJReplies: 35Last Post: December 3rd, 2007, 10:49 PM
By blakekri in forum Midnight Cafe'Replies: 8Last Post: May 18th, 2007, 05:14 PM
By wireninja in forum Other Affiliate NetworksReplies: 17Last Post: March 7th, 2007, 01:00 PM
By Fandango in forum Canadian AffiliatesReplies: 0Last Post: May 14th, 2004, 02:13 PM