Build me a single output file type from both online portals and excel files

We have multiple suppliers who provide price files at different frequencies, some are sent in via email and some have to be downloaded from a supplier portal.

We need to have a standardized output file to load into Salesforce, if possible we would like to be able to have test functionality to ensure that the outputs produce an expected outcome.

The naming conventions are different by supplier (mostly) and the format of the files can vary from one supplier to another. The template provided by the supplier (price files) typically remains consistent, but we need to be able to add or remove elements as part of the solution (when pricing becomes obsolete) or new products become available

Typically pricing depends on the contract start date, the location of the meter, the energy type, the type of meter etc. Attached is sample price files (we have approx 12-14 suppliers and price lists may be for Gas or Electric

We had someone create something but then did not have the opportunity to complete the task, see attached "Gas Template"

Habilidades: Excel, Salesforce.com, Processamento de Dados, Processamento de dados, Excel VBA

Veja mais: export sharepoint list to excel automatically, how to import data from website to excel 2016, pull data from excel file on sharepoint, excel get data from sharepoint folder, excel web query, power query, excel power query, excel data connection to sharepoint file, dat file type excel, simple excel type online database need, simple excel type online database need created asap, create custom excel file type, blank type online excel, automatically build graph text file excel, excel file type development, generate output file macro excel, output file excel format, program output file format excel, calyx point file type excel, excel macro example output file

Acerca do Empregador:
( 0 comentários ) Stoke-on-Trent, United Kingdom

ID do Projeto: #27496370

15 freelancers estão ofertando em média £208 nesse trabalho

(313 Comentários)

Hi, Greetings! ✅checked your project details: Build me a single output file type from both online portals and excel files ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of Mais

£250 GBP in 4 dias
(400 Comentários)
(248 Comentários)
(67 Comentários)

Hi there I'm ms Access/Excel/vba guru from Georgia- full time freelancer. I think better way will be to maintain this process via ms Access app/if you need with Excel automation. I'll detail more in private chat . Bes Mais

£500 GBP in 8 dias
(20 Comentários)

@@@@ Hello! @@@@ My name is konstiatyn who is professional in Visual Basic, Data Processing, Data Entry and Excel. I am very interested in your project”Build me a single output file type from both online portals and e Mais

£150 GBP in 3 dias
(1 Comentário)

hi sir/madam i have lot of experience like these project and i have done so many projects like this i can deliver within time and adjust whatever you asked please feel free to contact me for more details thank you

£30 GBP em 1 dia
(1 Comentário)

Hi, I can complete the task. However, I would like to know more details. It would be great if you walk me through the excel files

£150 GBP in 4 dias
(0 Comentários)

I have read all carefully. You can contact me. I can do it in two days. I have not done similiar work before . But trust me I can do it in two days

£167 GBP in 2 dias
(0 Comentários)

i can built that High Quality + Fast Speed = Excellent Result + Business Success, this is my work- ing style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 1 Mais

£90 GBP in 7 dias
(0 Comentários)

Hello, My name is Michael i would like to let you know that i'm a very hardworking and dedicated person, i only take payment when my client's smile on my output i will do my work with full honesty. i am a new freelance Mais

£135 GBP in 7 dias
(0 Comentários)

I am interested in this project. I have more than 5 years of working experience as MIS & Accountant. If there any opportunity for me please let me know. My Skills:- ✓Good Communication Skills ✓MS Office specially form Mais

£167 GBP in 5 dias
(0 Comentários)

Hi, I have substantial experience in excel leveraging VBA to automate daily mundane tasks. I have created complex customer management systems, user forms for efficient data entry to name a few. Let's connect and discu Mais

£60 GBP in 4 dias
(0 Comentários)

Hello, I am an freelance VBA Developer from India with total experience of 9+ years. I can deliver your requirement with precision on committed date, provided with content and material for build. I am a perfectionist a Mais

£250 GBP in 5 dias
(0 Comentários)
(0 Comentários)