Fermé

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 : need auditing, text string, data auditing, auditing i, excel code data entry, code data entry excel, excel refresh data code

Concernant l'employeur :
( 0 commentaires ) Australia

N° du projet : #8461936

24 freelance ont fait une offre moyenne de 166 $ pour ce travail

esalem

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
(13 Commentaires)
6.2
aarifakhtar

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
(75 Commentaires)
6.1
fabest

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
(20 Commentaires)
5.6
dviruki

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
(62 Commentaires)
5.2
kevivu

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
(34 Commentaires)
5.0
d2imatrix

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
(27 Commentaires)
5.0
vsprybhanu

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
(31 Commentaires)
4.5
privani

A proposal has not yet been provided

111 $ AUD en 2 jours
(14 Commentaires)
4.2
someka

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
(30 Commentaires)
4.2
surekash7096

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
(19 Commentaires)
4.1
umeshrathod1982

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

263 $ AUD en 5 jours
(2 Commentaires)
3.7
jnekam

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
(5 Commentaires)
3.6
barkatmulani

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)
2.9
zu02

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
(1 Commentaire)
2.7
logoDS761

A proposal has not yet been provided

200 $ AUD en 5 jours
(4 Commentaires)
2.7
clearatul0

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
(1 Commentaire)
2.5
serdaryalcin

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
(3 Commentaires)
2.1
simulnetcode1221

A proposal has not yet been provided

150 $ AUD en 3 jours
(3 Commentaires)
1.8
arsa89

A proposal has not yet been provided

155 $ AUD en 3 jours
(0 Commentaires)
0.0
pharaolancers

I am in expert in excel writing macros for 3 different companies including admin work and production planning. I can work with all basic formulas in addition to writing macros for such miscallaneous applications. Thus, Plus

50 $ AUD en 3 jours
(0 Commentaires)
0.0