Project Detail

Script or macro to handle Excell database  

Script or macro to handle Excell database is project number 288443
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: xxxjmt

Budget: $30-250

Created: 07/17/2008 at 11:37 EDT

Bid Count: 16

Average Bid:
$ 121

07/22/2008 at 11:37 EDT

Project Creator: buonmiceli
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

Hi everyone.
I’m Francesco Miceli, the owner of 2 eBay stores (http://stores.ebay.it/Bazaar-di-Baghdad and http://stores.ebay.es/Magicbazaar) and I need an Excel macro or a small program to post quickly auctions.
I work with Turbolister (http://pages.ebay.com/turbo_lister), a software that can import .csv files and send them to eBay.
I sell collectable gaming cards (Magic the Gathering and Yu Gi Oh), and I’ve built a database with almost every existing card – you can download it at http://www.2shared.com/file/3609616/45a461eb/MTG_Database.html

From column A to O there is info like English and Italian name, colour, type, rarity, price and so on.
From column Q to HC there is the CSV info for Turbolister: the columns with a red name changes from auction to auction
Finally there are 3 auxiliary columns (HF, HG, and HH) which help to “build” the auction html text using the concatenate command.

I need a macro or small program that:

1. Ask me for the name of the card I want to sell.
2. Check if there are more cards with the same name, and let me choose the right one with a drop down menu or something similar. Cards are often reprinted in different set: for example, if you search for “Black Knight” you’ll find it 5 times (Alpha, Beta, Unlimited, Revised, 4th and 5th edition), and every set has a different price.
3. Ask me for the quantity I want to sell and write the answer on the CSV “Quantity” column (AA) in the correct row (for example, if I have 12 Black Knight from the 4th edition it must write 12 in the AA29 cell).
4. Allow me to change the start price (column AD) for the card I’m working on or leave it with the default value.
5. Copy the part of the row with the CSV info (from column Q to HC) and past it to a new excel sheet (only the values, not the formulas), starting from row 2, column A (row 1 is reserved for Turbolister data) and adding every new subsequent card in the first free row. In the example file, it should copy the info in the CSV sheet.
6. Start again with a new card.

Than I’ll export the CSV file, load it with Turbolister and send it to eBay.

It must be possible to:

- Use the software on different Excel databases.
- Configure it to change the copy interval (by default, from column Q to column HC) if in the future I want to use it with a different database.
- Configure it to paste to a different initial row (by default, row number 2) if I want to modify or add cards to an existing file.


It’s not essential but it would be quite useful to:

- Type only part of the name to save time, choosing the right one from a list if there are many cards sharing part of the name.
- Colour red or another colour the row of the cards with an auction title (column T) with more than 55 characters (the maximum allowed by eBay), so that I can change it manually.
- To comment the code.

Please let me know if you have more question or need more info.
Best regards, Francesco

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

150

3 days

07-17-2008 12:14 EDT

Hello,You are at the right place.Please refer your PMB.Thank you.

help

 

128

5 days

07-18-2008 15:41 EDT

Dear Francesko! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

help

 

90

0 days

07-18-2008 01:31 EDT

************** HI, I WILL BE ABLE TO HELP YOU WITH THIS PROJECT. SEE PM. THANKS *****************

help

 

150

14 days

07-18-2008 12:07 EDT

Hello, Please check your Private Message Board for my detailed quote. Thanks!

help

 

130

7 days

07-17-2008 13:21 EDT

Dear Sir, I have good knowledge of excel and VBA. Can I make for you a script in Excel to execute whatever you want and even more (T column reduction, etc.). Because many details are discussed and verified will propose a longer period. Thank you.

help

 

120

3 days

07-17-2008 15:19 EDT

Good day, Sr. Miceli. I work with Excel and VBA. Mostly, for economic and accounting. But I like Card Games. :) So I'll be glad to write programme for your cards.

help

 

150

3 days

07-17-2008 12:40 EDT

(No Feedback Yet)

Hi, have 2 years experience in similar kind of work,can complete your work on time. Check your PMB.

help

 

120

3 days

07-17-2008 13:16 EDT

(No Feedback Yet)

i have done lots of this kind of projects

help

 

180

4 days

07-17-2008 13:31 EDT

(No Feedback Yet)

I have 4 yrs of experience in scripting and can complete the job with the best quality in 4 days.

help

 

120

3 days

07-17-2008 22:31 EDT

(No Feedback Yet)

I have been writing script and macro to interact web sites with excel many times and still doing it. Contact me, you will never regret.

help

 

140

6 days

07-18-2008 08:51 EDT

(No Feedback Yet)

Dear Sir or Madam, I Think I'am right person for your project. I have enough knowledge on Excel and Access. Pls know me farther details.

help

 

95

7 days

07-18-2008 09:50 EDT

(No Feedback Yet)

Hello, I have over 10 years experience in creating Excel VBA tools as you have described for large companies and for individual projects such as this one. I can finish this quickly and accurately and will make sure you are happy with the results.

help

 

137

7 days

07-18-2008 14:05 EDT

(No Feedback Yet)

i have exp of over 10yrs of working on excel spread sheets and data entry job...........work will be to the best of your satisfaction.....parvinder

help

 

150

7 days

07-19-2008 02:14 EDT

(No Feedback Yet)

Respected Sir, i m Nakul sharma, I have more than 5 year of experience in Data Entry.If you give a chance to work on your project.I will fulfill your requirement. Thanks

help

 

50

3 days

07-19-2008 07:20 EDT

(No Feedback Yet)

Dear sir,let me to do this work successfully.

help

 

30

5 days

07-19-2008 09:48 EDT

(No Feedback Yet)

Dear Sir, Thank you very much for your posted project. I am very pleased to see your project type. I have read your project requirement and sure to say that I am the right person for doing this work. In fact , I have good experience in data entry, access and excel. Moreover, I am very capable and dependable with high level of accuracy and speed. I have done similar kind of work . So you will must get maximum benefit from me. I look forward to response from you. Thanking you, Yours truly, Razaul0.

help


    Bid on this Project