Sedang Disiapkan

Script or macro to handle Excell database

Hi everyone.

I’m Francesco Miceli, the owner of 2 eBay stores ([url removed, login to view] and [url removed, login to view]) and I need an Excel macro or a small program to post quickly auctions.

I work with Turbolister ([url removed, login to view]), 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 [url removed, login to view]

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

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel

Lihat lebih lanjut: excell database, magic gathering excel card database, magic gathering excel database, script excell, excel macro magic card price, you di it, write ad copy, work excell, want to post a ad, to the maximum, time card example, software data entry free download, search red, red search, red or black, red black data, q find, need excell help, in the red black, i need help to write an ad, html 5 edition+, html 5 command, gaming program, free html 5 download, free excel program download

Tentang Majikan:
( 13 ulasan ) Madrid, Spain

ID Projek: #288443

Dianugerahkan kepada:

xxxjmt

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

$90 USD dalam 0 hari
(10 Ulasan)
3.4

16 freelancers are bidding on average $121 for this job

MAnkita

Hello,You are at the right [url removed, login to view] refer your [url removed, login to view] you.

$150 USD dalam 3 hari
(104 Ulasan)
6.3
johnsinit

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

$128 USD dalam 5 hari
(14 Ulasan)
4.0
JackBradford

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

$150 USD dalam 14 hari
(7 Ulasan)
3.5
ioanaprof

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 pr Lagi

$130 USD dalam 7 hari
(13 Ulasan)
3.5
MaxCalif

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.

$120 USD dalam 3 hari
(1 Ulasan)
2.0
pravly

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

$150 USD dalam 3 hari
(0 Ulasan)
0.0
shazmi

i have done lots of this kind of projects

$120 USD dalam 3 hari
(0 Ulasan)
0.0
hireboy

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

$180 USD dalam 4 hari
(0 Ulasan)
0.0
chongsa

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.

$120 USD dalam 3 hari
(0 Ulasan)
0.0
akram1234

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.

$140 USD dalam 6 hari
(0 Ulasan)
0.0
bressr

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 Lagi

$95 USD dalam 7 hari
(0 Ulasan)
0.0
parvinder1137

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

$137 USD dalam 7 hari
(0 Ulasan)
0.0
NAKULSHARMAA

Respected Sir, i m Nakul sharma, I have more than 5 year of experience in Data [url removed, login to view] you give a chance to work on your project.I will fulfill your requirement. Thanks

$150 USD dalam 7 hari
(0 Ulasan)
0.0
THILAK86

Dear sir,let me to do this work successfully.

$50 USD dalam 3 hari
(0 Ulasan)
0.0
razaul0

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 g Lagi

$30 USD dalam 5 hari
(0 Ulasan)
0.0