In Progress

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

Skills: Excel, Visual Basic, PHP, Software Architecture, Data Processing

About the Client:
( 8 reviews ) New York, United States

Project ID: #33775011

Awarded to:

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 More

$10 USD in 2 days
(0 Reviews)
0.0

30 freelancers are bidding on average $50 for this job

(482 Reviews)
7.7
(281 Reviews)
7.0
(187 Reviews)
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 More

$80 USD in 2 days
(33 Reviews)
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 More

$20 USD in 1 day
(174 Reviews)
7.1
(276 Reviews)
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 ) More

$20 USD in 7 days
(119 Reviews)
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 More

$55 USD in 1 day
(169 Reviews)
6.5
(133 Reviews)
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 More

$80 USD in 2 days
(16 Reviews)
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 More

$10 USD in 1 day
(41 Reviews)
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 days
(126 Reviews)
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 More

$110 USD in 2 days
(168 Reviews)
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 More

$120 USD in 5 days
(5 Reviews)
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 More

$50 USD in 3 days
(14 Reviews)
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 More

$30 USD in 1 day
(18 Reviews)
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 More

$20 USD in 1 day
(13 Reviews)
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: - More

$20 USD in 3 days
(2 Reviews)
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 More

$20 USD in 7 days
(0 Reviews)
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 More

$20 USD in 7 days
(0 Reviews)
0.0