Em Andamento

Excel file consolidation and retrieval

1. Create a macro based home page with buttons like - consolidate files , scan files and report

2. On click to consolidation, system opens the upload file option and user selects excel file to upload it. Other file format if used will throw error

3. Upload files will consolidate and throw duplicate row errors (if any)

4. Scan file will give option to user to scan the records in text file. It will handle no record found and duplicate scan error. On submit system will enable generate report button. On this report will be generated based on report selection. All scanned records will be removed from the consolidated file.

3. Generate report will regenerate report of already scanned based on date and show I scanned report with ageing. And alos create summary report date wise - total records consolidated, total scanned and total unscannes

Habilidades: Excel, Visual Basic, PHP, Arquitetura de software, Processamento de dados

Sobre o Cliente:
( 8 comentários ) New York, United States

ID do Projeto: #33775011

Concedido a:

yevheniitsvietk3

hello dear. I just saw your posting and I am interested in your idea. I have vast experience about visual basic and macro. Before some months, I used macro to analyze data in excel for my friendly client. I want to wo Mais

$10 USD em 2 dias
(0 Comentários)
0.0

30 freelancers estão ofertando em média $50 nesse trabalho

(482 Comentários)
7.7
(281 Comentários)
7.0
(187 Comentários)
7.0
maxpl

Hello Sir, Hope you are doing great. I am an experienced web and mobile app developer. I am working as a developer for last 8+ year Mais

$80 USD in 2 dias
(33 Comentários)
6.7
daniyal3214

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Mais

$20 USD em 1 dia
(174 Comentários)
7.1
(276 Comentários)
7.0
BitLabs

Dear sir, I have gone through your outsourced requirement " Excel file consolidation and retrieval " and have analyzed that I have right credentials ( PHP Visual Basic Data Processing Excel Software Architecture ) Mais

$20 USD in 7 dias
(119 Comentários)
6.7
AccountantArman

"Sir, I can calculate it calculate Frequency, Amplitude, Phase, spectral analysis and Phase Diagram from Discrete Data I am an Excel Advanced Level Expert. This is basic work for me. I can complete this project with a Mais

$55 USD em 1 dia
(169 Comentários)
6.5
(133 Comentários)
6.1
arnoldb

Hello, I hope you are doing well. I am full stack developer from Poland with more than 8 years of experience. I have seen the project descriptio Mais

$80 USD in 2 dias
(16 Comentários)
6.0
Sohail748

Hi There....I will give you 25% Discount on my all services. Let’s get to the Project. Your Looking for a developer that expert in. Php development. you need .excel file consolidation and retrieval According to Mais

$10 USD em 1 dia
(41 Comentários)
5.5
PERPETUAL0

Hello there i can show you some previous reports also for the first steps i can regards ILYAS

$150 USD in 3 dias
(126 Comentários)
5.7
merinsinha

Senior excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this Mais

$110 USD in 2 dias
(168 Comentários)
5.8
vw1514518vw

Hi, I developed hundreds of code scripts for clients without a single issue, ready to develop the required macro as follows 1-Load excel files, validates, log and create basic report for duplicate records,date..etc su Mais

$120 USD in 5 dias
(5 Comentários)
4.0
abatsis

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrams, Data Entry, IoT, Industrial IoT, Power Mais

$50 USD in 3 dias
(14 Comentários)
4.2
rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Mais

$30 USD em 1 dia
(18 Comentários)
3.9
Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Mais

$20 USD em 1 dia
(13 Comentários)
3.6
prasitkeng

Hi prospective client, I'm an engineer who has been working with VBA for more than 6 years now. I regularly create VBA program to consolidate several Excel reports into a single file. My experiences in Word VBA are: - Mais

$20 USD in 3 dias
(2 Comentários)
1.1
iffahafiqah98

Hello there, It is my great honor to apply for this vacant job. I am very hardworking and can work effectively as fast as I can. I have excellent skills in Data Entry, Web Research and Microsoft Office and I have en Mais

$20 USD in 7 dias
(0 Comentários)
0.0
kshakyrah

Hello dear client from UK, My name is shakyrah, am a versatile virtual assistant, with more than 4 years experience of doing data entry and processing, email handling, Internet search, administrative support etc. I am Mais

$20 USD in 7 dias
(0 Comentários)
0.0