XenoX101
Distinguished Member
- Joined
- Aug 25, 2008
- Messages
- 4,606
- Reaction score
- 20
Hello So the deal is I've made this spreadsheet in excel that collates a bunch of brands, clothing items and sizing into a convenient search web address and/or search string. It took me about 2 months and is the first time I've had to delve into macros, to be honest if I knew of the time and effort I'd end up spending on this thing I wouldn't have bothered, but its done now and I'm pretty happy with the result. Have a play, see if you can make some use of it, it has the capability for a large number of keywords so you have plenty of space to add your own and I've written the macro so that you do not need to touch any code to add keywords, just follow the instructions on Sheet2. I will post updates as they happen and certainly welcome any feedback you can give on the program, even if its just to say that you are using it. Btw, the categories you see are of your own choice, I simply left my choices in there as an example Also I am aware that narrowing your searches will lead to missed opportunities, but its a balancing act, you can broaden the amount of brands you search and then be more specific about what sizes you want. Experiment. Notable Features: Brand Concatentation - combine up to 70 brands into a single search string Preset Keywords + Create your own - choose preset item keywords or create your own Unlimited Characters - the generated web address means you can exceed the 300 character search box limit to a very high and so far unknown number of maximum characters Generates Search Web Address - creates a simply copy>paste web address for the search eBay Search Creator 1.0 Screenshots
Download from Slingfile from Mega Upload from Easy Share from SendSpace