Analyze some Data and write a code in Excel to automate the analysis process

Auditing an existing spreadsheet.

I have an original spreadsheet with data already entered into it. Unfortunately the data is not 100% correct. We have done fieldwork to acquire the correct data, and now we need to edit the original spreadsheet and correct it with the new data.

1. The new data comes in 6 different folders, with each folder having between 10 to 16 files. Each folder needs to have the data from every file in it combined into 1 new file per folder.

2. Once we the 1 combined file per folder we then need to use it to edit the original spreadsheet. There is 1 original spread sheet per folder as well.( at the moment I am doing a manual analysis and editing rows manually (inserting/deleting) and have a vlookup function pasted over the entire sheet. I am also using my combined file, the original file, and a new file which is a copy of the original which has become my working file)

I need to automate a process that can search for a text/number string from column B in my combined file and find it in the original file and then add or delete rows from the original until the number of rows allocated to that particular text/number is equal to the number of rows allocated in the combined file. After that the original file then needs to update only specific columns with values from the combined file. Once this has been achieved the data needs to be highlighted YELLOW.

IF the text/number does not exist in the original file then the data needs to be added to the bottom of the list and highlighted BROWN.

IF the text/number coming from the combined sheet indicates that there is no requirement for data then certain parts of the original data will remain however the columns that are otherwise being copied from the combined file will be left empty and the row will be highlighted BLUE.

IF the text/number coming from the combined file indicates that there is no requirement for data AND that text/number DOES NOT exist in the original then that text/number will be placed onto another sheet.

That is all. If you can write a button do compile all the files into 1 file and then another button to do the analysis and editing that would be great. Also just let me know what parts of the code will need to be changed so that the button will work for each and every folder that I need to use it for.

Please contact if you have ANY queries. The faster we can resolve this the better.

I have included a completed version of this. file name 2ARM FSAM 04 FINAL REPORT

I have also included an orignal file for the next area 2ARM-05-INF-02 Pole Utilisation Report 20150701150208

and some of my files from the fieldwork we have done

2ARM-05-02 SB ipad cf

2ARM-05-03 Pole Utilisation Report SB JAKE

2ARM-05-04 Pole Utilisation Report SB JAKE

Compétences : Traitement de Données, Excel, Visual Basic

Voir plus : what is a search string, what is a copy, the need for auditing, text to string, some search string, i can write my name, excel for data analysis, data auditing, brown and brown, auditing i, excel code data entry, comparing excel files data report code vb, code data entry excel, excel extract data url code, excel postal code data entry, excel code vbs vba data base, excel macro data process example, excel refresh data code, excel vba code data web page, code install analysis toolpak excel

Concernant l'employeur :
( 0 commentaires ) Australia

N° du projet : #8461936

24 freelance font une offre moyenne de $166 pour ce travail


You dont need to recruit me to finish this. Drop me a message, and lets see what i can do for you. If you get happy, we can progress. (as i need some good references in my profile, i provide this service) I have a 5 Plus

188 $ AUD en 2 jours
(137 Commentaires)

Hi: Here's my suggested solution: I will provide an option to select the folder and select the original file. Then you can press the button. The program will then work on the rules defined by you and will create a new Plus

140 $ AUD en 3 jours
(148 Commentaires)

Dear, We are Team of 3 developers, French and US Team. We can develop your Website/App in few days. - Please give me all project description and I will come back to you shortly. As you can see I have very good rate Plus

200 $ AUD en 3 jours
(58 Commentaires)

Hi, I am VB and GIS developer and well versed in Excel and programming of Excel using VBA or even developing Add-in for Excel using VSTO of .NET. I gave also courses in Excel for UN employees here in Palestine - Gaz Plus

277 $ AUD en 5 jours
(20 Commentaires)

Dear Sir/Madam, I have 12 years of experience in automation of data processing and analysis using Excel and VBA while working in finance, audit and accounting industries (including 4 years at a Big 4 audit firm). My re Plus

97 $ AUD en 3 jours
(66 Commentaires)

Dear Sir, Done numerous similar projects in past the and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Plus

222 $ AUD en 3 jours
(73 Commentaires)

I'll do it via Access/Excel automation Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, s Plus

277 $ AUD en 3 jours
(27 Commentaires)

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in Exchange data between sheets, Critical Programming, Developing System for Management and Creating Reports. I've read and understood your project d Plus

140 $ AUD en 3 jours
(61 Commentaires)

A proposal has not yet been provided

111 $ AUD en 2 jours
(33 Commentaires)

Hi, We are experts in excel based operations, data processing and VBA automation. We can do this job for you. Kindly message us for further discussions. Regards, Pal

100 $ AUD en 2 jours
(33 Commentaires)

I have the expertise in Excel and can write the script for the defined specifications to automate the analysis process. Ready to start work immediately

155 $ AUD en 3 jours
(68 Commentaires)

Hi, I have completed many projects like this one for the insurance company that I was working (now I am their freelance consultant) It would take sometime between half a day and one day, I think my offer is fair Plus

166 $ AUD en 3 jours
(21 Commentaires)

Have already done this kind of task for one of the company for their sales department.

263 $ AUD en 5 jours
(2 Commentaires)

Hi There are easy ways to do that kind of complex and boring job: using macro to read and copy data in files situated in folders, without even opening them. So I can write a button do compile all the files into Plus

250 $ AUD en 10 jours
(12 Commentaires)

I started working in Excel since the start of my career in 1998. MS Office used to come along-with Windows 95 installation at that time. I have experience in developing data enter/edit functionality in MS Excel using V Plus

99 $ AUD en 7 jours
(6 Commentaires)

I am writing to express my interest in working as a VBA Macro Developer. I am especially interested in a position documenting Excel applications or in a position that coalesces with my areas of interest or expertise: E Plus

222 $ AUD en 3 jours
(2 Commentaires)

A proposal has not yet been provided

200 $ AUD en 5 jours
(4 Commentaires)

Hi - I can do this work for you in MS Access - it will make your life much easier having your data in a proper database application, and will make importing, exporting, searching and comparing information 100% eas Plus

250 $ AUD en 3 jours
(1 Commentaire)

I've worked with data in Excel spreadsheets a lot in the aircraft industry. I have also created macros for data compilation and analysis.

35 $ AUD en 3 jours
(1 Commentaire)

A proposal has not yet been provided

35 $ AUD en 3 jours
(0 Commentaires)