Lukket

Copy and update fields Excel macros

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!

Færdigheder: Databehandling, Excel, Visual Basic

Se mere: programming symbol, programming macros, kolor code, excel data programming, copy write name, ask excel, amy red, vat eu, symbol red, excel sheet formula, eu vat, basic html programming, xml excel, run update, pno, names column, excel w, excel duplicate, amy, amy d, update status code, names simple shop, macros excel basic, column already exists, excel macro row

Om arbejdsgiveren:
( 0 bedømmelser ) India

Projekt-ID: #5980925

15 freelancere byder i gennemsnit $36 for dette job

AndroidAll

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. Regards. PS. "excel2010"

$35 USD på 1 dag
(10 bedømmelser)
4.0
JonNxt

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have many years of experience working with macros and writing code / debugging Excel VBA code. You may che Mere

$30 USD in 2 dage
(3 bedømmelser)
2.6
abhinovpankaj

Hi, I am working as software professional in IT industry from last 3 years. I work on VB scripting along with VBA for MS office applications mainly Excel I have done these type of similar projects before. You cou Mere

$33 USD in 3 dage
(5 bedømmelser)
2.6
uframos

Hello there! I think I’m the right person for this job because, I work with excel/VBA for several years, I’m responsible and I promise you won’t regret hiring me! Regards, Filipe Ramos

$25 USD in 7 dage
(1 bedømmelse)
2.3
ssviatlana

excel2010 Hello! I think I can help you. I have advance experience with Excel. Unfortunately you have not downloaded the xls file. It would help to more accurately estimate the amount of work. I worked as an an Mere

$30 USD in 2 dage
(1 bedømmelse)
1.6
syedehtesham555

i am hard working i am doing this ................................................................................................................................

$20 USD på 1 dag
(0 bedømmelser)
0.0
abhijeetraj

I am Hard Working and punctual. All that matters Thank you for the opportunity. I will be looking forward for your reply.

$25 USD på 1 dag
(0 bedømmelser)
0.0
bjornclopterop

hi, I am new here, so please give a new freelancer the possibility to convince you. I promis, I will not disapoint you! I have more then 3 years experience with VBA Thanks for your feedback Regards Bjorn

$25 USD på 1 dag
(0 bedømmelser)
0.0
oprovider

I am expert in writing excel macros. I will do your project in least time. Please message me, so i we can discuss it and start asap. You need to pay, when work in 100% done and you satisfy completely. Regards, T Mere

$35 USD på 1 dag
(0 bedømmelser)
0.0
Humphrykim

Excel 2010 My skills are ideal and I assure you quality work delivered within the agreed time. Customer satisfaction is one of my key objectives in all of my projects. I will ensure that I provide you with value for Mere

$70 USD på 1 dag
(0 bedømmelser)
0.0
Pharoa

excel2010 Thanks for the opportunity to bid on you project. I have read your tender and understand your requirements. I will bring over 20 years experience building full featured applications with Ms Excel to Mere

$111 USD in 5 dage
(1 bedømmelse)
3.0
sunilray

A proposal has not yet been provided

$15 USD in 4 dage
(0 bedømmelser)
0.0
bhumika42

I am 7 years of experienced in VB.Net and VB6 with SQL Server and have worked on many such VB6 projects for development and modifications which includes formulas, formatting, complex calculations & graphs.

$20 USD in 2 dage
(0 bedømmelser)
0.0
pnrfreelancer

Hi, We've 10 years of experience in field of excel,VBA, VB,.Net programming,MS Access, MySQL, SQL Server & Sql Express 2005. Please give us a chance to fulfill your requirements. Please see our Elance profile. Mere

$25 USD in 2 dage
(0 bedømmelser)
0.0
Samar86

Pretty sure I can finish this within a short time! Have a lot of experience in excel both professionally and academically!

$25 USD på 1 dag
(0 bedømmelser)
0.0
pujabhusari

excel2010 Hi, I will need to see the excel sheet before we start the project. I have fair amount of exposure in excel and I am sure this can be done with ease. I have understood the requirements Top level, but i w Mere

$35 USD in 2 dage
(0 bedømmelser)
0.0