I need to check pricing on my website daily. In order to do this I must download an xml file from the site and check it against an xls spreadsheet. I do this manually and want to automatic the process. I need someone to give me the ability to read the new file each day and amend the old document - add, remove, update, amend etc.
I'm happy for this to be done in either Excel or Filemaker, but I guess Filemaker would be better.
I have added 2 files as an example of what I want done. The file labelled 'Daily update' has a part number, qty and cost'. I want this file to update the 'Web file to update' file with the 'part number, qty and cost'. If the product doesn't exsist, then needs to be added in the 'product number, qty and cost' in the correct columns / spots.
Good afternoon. I'm very interested in your project.
As a former website developer and Excel programmer I'd like the opportunity to get involved again in automated procedures like the one you're talking about.
Kind regards
Andrew Gibson
$38 AUD en 7 días
5,0 (1 comentario)
1,3
1,3
11 freelancers están ofertando un promedio de $102 AUD por este trabajo
Hi, I can do it with VBA for excel. Please send sample of excel and xml file you currently use and more detail requirements.
Looking forward to hearing you,
Cuong NH
I am sincerely read your requirements and am ready to endow with the solution as per your requirement.I have good typing speed with 100% accuracy. And much experience of this kind of work.