The job is make for Excel-VBA
look in the file in attachement.
1. sort and copy all the lines with the word "Sofort lieferbar" in a new sheet
in the new sheet:
[login to view URL] at "ISBN" and copy it into A
[login to view URL] first and second box bevor "ISBN" into B and C
4. the first box after "ISBN" into D
5. search at "EUR" and copy into E
6. search at "Stöbern in:" and copy into F
7. the first box bevor "Kunden, die diesen Titel" copy into G
Proje No: 46886
Proje hakkında
14 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 17 yıl önce
Biraz para mı kazanmak istiyorsunuz?
Freelancer'da teklif vermenin faydaları
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
14 freelancers are bidding on average $55 USD for this job
I've done a user_form where:
1) you can choose the source sheet
2) you can choose the comunn where the data to search is stored (default is 'Q' I guess...)
3) you can pick your value between a list of unique values
4) you can choose the name the new sheet
and then
5) the macro performs the actions as you request
I'm looking forward to hearing from you.
Regards,
step
I have been designing, writing and implementing applications created with macros and Excel for 4.75 years in my current job. I also use Access, SQL Server abd Visual Basic 6.0. I can provide you with what you request easily.
thanks
Hi. The BID is for $20 dlls. I'm willing to loose some money for a good review. I'm new at getafeelancer But I have many years of experince applying macros.
Thanks & Best Regards
Hello,
I can automate this process very quickly. I am certified as a Master Instructor in all of the Microsoft Office products and have over 12 years of experience integration software products.
United Informatics is a leading web designing firm. We deliver a full spectrum of innovative web solutions designed to help clients harness the power of the Internet to transform their business for the new century.
United Informatics helps global companies and Internet ventures leverage their existing business strengths to develop profitable and sustainable digital businesses. Driven by client needs, we identify e-business opportunities and utilize our conceptual, technological and marketing expertise to build, distribute and manage custom digital solutions for our clients.
We are available on a New Jersey (USA) telephone number for easy contact & consultation
Done. Takes account of data not being in the expected columns. Assumes you ONLY want columns A to G on the new sheet. If you have many rows of data it is fast (a whole sheet of 65536 rows takes 21 seconds). Macro and instructions provided.