Hello everyone,
I need some macros, basic Excel programming. Real deal, I need it to be done. Please write in your bid "excel2010".
There are 5 sheets in attached xls file.
1. First one (1)"XML" has list of products with details.
In columns 'Q' & 'T' are different images of the same product, rows are duplicated for each image.
Products are best distinguished by code in column 'L'.
2. Second sheet (2)"EXPORT ISTORE" has data exported from an e-shop.
3. In third sheet (3)"IMPORT" I need to have data copied from (2)"EXPORT ISTORE" but updated with fresh data from (1)"XML".
/offer/cena_brutto_detal -> 'Cena brutto'
/offer/cena_brutto_hurt_braz -> 'Cena promocyjna'
/offer/category -> 'Kategoria sklepowa' (fields containing 'Torby' should be changed to 'Torby Męskie')
/offer/brand -> 'Producent'
/offer/code -> 'Symbol'
/offer/color -> 'Kolor'
/offer/fabric -> 'Materiał'
/offer/quantity ->'Ilość w magazynie'
/offer/deliver_time_houres -> 'Wysyłamy w ciągu' ("1w" if quantity/Ilość w magazynie is 0, "24h" if quantity is more than 0)
/offer/description -> 'Opis HTML'
/offer/meta_keywords -> 'Słowa kluczowe'
/offer/meta_title -> 'Opis skrócony'
/offer/name -> 'Nazwa produktu'
/offer/warranty_months -> 'Gwarancja'
/offer/weight -> 'Waga'
Some of the products in (1)"XML" can no longer be found in (2)"EXPORT ISTORE". If there is a product with a code/Symbol in (1)"XML" that does not exist in (2)"EXPORT ISTORE", it needs to be added at the bottom of the (3)"IMPORT" sheet and highlighted in green.
This needs to be checked also the other way. If there is a product (code/Symbol) in (2)"EXPORT ISTORE" that no longer exists in (1)XML, it should be still copied to (3)"IMPORT" but the row highlighted in red.
For the rest of the fields:
'Identyfikator produktu' - empty for a new product row copied from (1)XML, the same for ones that already exist
'Status promocja' - new item gets "N", old stays as it was
'Status nowość' - new item gets "Y", old stays as it was
'Aktywny' - new item gets "Y", old stays as it was
'Dostępność produktu' - new item gets "D", item that is no longer available (highlighted in red) should be changed here to "NZ"
'Kategoria iStore' - the same for old and new items
'Gabaryt' - the same for old and new items
Additionaly there need to be run a check for duplicate names in "Nazwa produktu". Such issue could be marked with another third color.
4. Sheet (4)"EU STORAGE" is simple. It should have another button with a macro that copies things from (3)"IMPORT", if they are different.
'Nazwa produktu' -> 'Nazwa'
'Waga' -> 'Waga'
'Ilość w magazynie' -> 'Stan'
'Cena promocyjna' -> 'Cena zakupu'
'Gabaryt' -> 'Gabaryt'
'Katalog' - stays the same for old and new items
'ID' - new item empty, old one stays the same
'Stawka VAT' - the same for all fields
Products and duplicates here should be distinguished by name (nazwa). Coloring same as before.
5. Sheet (5)"EU AUCTIONS". Also copied from (3)"IMPORT". Duplicates should can be distinguished by title (TYTUŁ) or code ([SYMBOL]).
'Symbol' -> '[SYMBOL]'
'Nazwa produktu' -> 'TYTUŁ' and '[NAZWA]'
'Cena promocyjna' -> '[BRUTTO]' and 'WŁASNE NOTATKI'
CENA_KT - should have a following formula: IF(D2<100; 9%*D2; 9+6%*(D2-100))+D2 (D2 are fields from column [BRUTTO])
'Opis HTML' -> '[OPIS]'
Now time for columns 'ZDJĘCIA' and [ZDJECIE_1], [ZDJECIE_2] etc. These are photos which should be taken from (1)"XML".
First photo of particular product (code/symbol) from column '/offer/image' should be put in 'ZDJECIA', the rest should go into '[ZDJECIE_X]' columns. First photos from '/offer/image', then from '/offer/gallery_image'. Sometimes there may be missing photos in one column so the first photo should be taken from the other.
If you have any questions just ask, I need it in 48 hours. I don't accept pasted bids without the keyword.
Thanks!
Hi,
Here it is excel2010
Sounds interesting .. I I can do this quickly for you. Please have a look at my portfolio and latest projects ..
In short, I have been working with Excel macros for every long time ..
I am ready to start or to do a sample.
All the best with your project
Vishy
$35 USD en 1 día
5,0 (12 comentarios)
3,8
3,8
9 freelancers están ofertando un promedio de $82 USD por este trabajo
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
excel2010
Hi,
Let me introduce myself as an expert VBA programmer. I have used VBA extensively for writing macros in Excel, MS Word etc..
I have more than 10 years of experience to my credit.
I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc..
I fully understand on this highly competitive site how important it is to provide high quality work.
My prime focus is 100% customer satisfaction.
I would be happy to answer any queries that you may have.
Looking forward to working with you.
Thanks & Regards
FineCoder
Hello ,
I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel database and VBA on several projects .
My last job was database consultant within Accenture ,for more than 4 years .I worked for several projects relating with Microsoft databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..).
I have strong skills in MS Excel and VBA to develop all types of requirements related ,and given my experience, i am persuaded to give you to give High quality of work delivery withing budget and time
Best regards,