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
24 freelance ont fait une offre moyenne de 166 $ pour ce travail
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
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