Sedang Disiapkan

Build a generic excel/vba code for stable data transformation

we get periodically various excel sheets or text-files in various formats. we need an excel/vba based solution (no addtional technology to be used used) which does only do one job: stable und realiable data transformation

- structure:

1) admin tab(s) --> here the user will manage (without coding) metadata for data-delieveries (excels or txt or csv ) , expected columns and corresponding format per column , transformation rules per column and basically one button to start the relevant transformation according to managed me

2) input tab (here after delievery the received data will be copy pasted into)

3) output tab (here the generated/transformed data will be available) for the user

4) job reporting tab --> show potential problems/exceptions when tools tries to transform the data (example : delievered data does not comply with definition in admin section (amount of columns or name of columns or delievered or dataformat not complying for correct columns, aso) , generated exception list + generate corresponding error/exception message

remarks:

- must be based on excel/vba, no addtional technology to be used,

- code will be owned by client after delievery and must be editable by client (assuming client has vba know-how

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi, Kejuruteraan Perisian

Lihat lagi: excel automation tools, vba excel examples, excel automation without macros, useful vba codes for excel, easy excel automation download, vba excel, excel automation tools open source, free excel automation tools, excel vba access sheet data, excel vba code optmization, excel vba code optimis, excel vba return xml data type, excel vba code log websites, outlook 2003 vba code extract data, excel vba update imported data, excel vba code open internet explorer, inventory excel vba code, excel vba code data web page, excel vba code pull internet data, vba code update data excel

Tentang Majikan:
( 0 ulasan ) Zurich, Switzerland

ID Projek: #23513765

Dianugerahkan kepada:

rashedkhanrubel

Hi, I have understand the project requirement & interested to work for this project. I will start right now. Please send a message so we can discuss more & start the project. Thanks.

$250 USD dalam 3 hari
(101 Ulasan)
5.5

22 pekerja bebas membida secara purata $478 untuk pekerjaan ini

asin1987

Dear Employer, I will strictly do the job on VBA and will send the code to you which will be then owned by you. Please message me to discuss further. I am an expert with over 13 years of VBA experience. Thanks and Re Lagi

$500 USD dalam 5 hari
(219 Ulasan)
7.8
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$350 USD dalam 5 hari
(345 Ulasan)
7.4
AwaisChaudhry

Hi, I have read the brief details on the job listing. I am a full stack web developer with 9 years of coding experience. I have worked with multiple similar jobs before. I have completed 150+ major projects just on thi Lagi

$750 USD dalam 9 hari
(45 Ulasan)
7.3
branislavm

Hello! Can you share files that contain some data where I can see the format of the text files? Also, I need a file with an output format. As requested, I'll use only Excel /VBA for this. Regards, Branislav Mihaljev

$650 USD dalam 7 hari
(251 Ulasan)
7.0
polarjin2017

I have done a lot of projects with Office/vba. I have plenty experience in here. So i can help you if you want. Hope to work with you. Thanks. -examples: [login to view URL] [login to view URL] Lagi

$555 USD dalam 10 hari
(153 Ulasan)
7.1
nagyzoltan68

Hello, I would like to work on your project. I have a great experience using excel macros / VBA, data formatting and data manipulation in excel, working with multiple files, transferring data with/without changing data Lagi

$300 USD dalam 4 hari
(123 Ulasan)
6.5
SShtv

Hello, I am interested in your proposal and I am ready to solve your task. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.

$500 USD dalam 7 hari
(90 Ulasan)
6.0
zu02

Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. I’m Ms Access/VBA develop Lagi

$500 USD dalam 7 hari
(37 Ulasan)
5.9
daniyal3214

I am a professional Data Analyst, Data Scientist and Data Visualization expert holding years of experience. in Excel, VBA, SQL, Power BI, Tableau and various other tools to perform automation and develop dynamic and au Lagi

$250 USD dalam 2 hari
(53 Ulasan)
5.5
AITSoft

Hello there, How are you doing?. I have read the description, I have great experience doing similar jobs related to these skills Excel, Software Architecture, Visual Basic, Visual Basic for Apps. Right now I am plac Lagi

$555 USD dalam 12 hari
(22 Ulasan)
4.6
arash18k

Hi, I can write a VBA code in which you be able to specify the settings in the admin tab and then the transformation be done via Excel, However, may I see one form each of your csv, txt and the raw excel. please send m Lagi

$300 USD dalam 7 hari
(12 Ulasan)
4.4
y2klewis

Hi, my name is Daniel, i am an Excel Expert and vba programmer, i am sure i can do your project really fast and really accurate,. I will send you the first draft of the Excel file just in one day, and after that i will Lagi

$690 USD dalam 10 hari
(15 Ulasan)
4.0
MaLiguo

Hello ( ͡ᵔ ͜ʖ ͡ᵔ ) I am a full-time freelancer with rich experience and high skills in Excel / VBA / PDF / WEB programming. I have read your requirements carefully and understood what you want. I am sure I can comple Lagi

$500 USD dalam 7 hari
(6 Ulasan)
3.7
antinivanov1220

~ ~ ~ PROPER BUDGET && SHORT TIME && HIGH QUALITY ~ ~ ~ How are you. i've review your post carefully and interestly. I am expert visual basic. You will be fascinated by my skills. i'd like to help and finish your pro Lagi

$300 USD dalam 5 hari
(4 Ulasan)
2.9
athminteam

Hi, This is Vipin. I have 6+ years of experience in customized software, web and mobile app development and have expertise in Android, iOS, Python, Magento, PHP, HTML, Java, Angular and Ionic framework. I would like Lagi

$500 USD dalam 7 hari
(4 Ulasan)
2.4
TaiZhe0224

Hi, This is Jin from China. I read your post with interest and I can handle it. I have developed many Windows desktop applications in various fields including Office Automation. Especially I have a lot of experience i Lagi

$500 USD dalam 7 hari
(1 Ulasan)
1.0
krupalitechexper

Hey, glad to inform you that have done S-I-M-I-L-A-R project in past. Do you want to check the D-E-M-O ???? Thanks.

$500 USD dalam 7 hari
(0 Ulasan)
0.0
Akashmehetre80

I am professional data entry worker and I have Completed Tally ERP 9, DTP, Ms Office, Ms Cit, Excel

$500 USD dalam 7 hari
(0 Ulasan)
0.0
thomaspol917

Hello, Thank You For Job Posting :) I have 6+ years of experience in Website and Application development. I have checked The requirement and understand that as well. I have created SIMILAR in past. Do you want to Lagi

$500 USD dalam 7 hari
(0 Ulasan)
0.0
bharatsutar

dear sir i am having good experience of data processing and VBA coding in excel. i think you got perfect man to do this task. for any work to do with accuracy need time. thank you

$555 USD dalam 3 hari
(0 Ulasan)
0.0