En cours

Write VBA to Summarize All Excel Files in Folder into Another Spreadsheet

I have a series of reports that are downloaded from an online service. They always have different names, but their format is always identical. Each report includes a personal scorecard for a different user.

Each scorecard contains a list of tests that the user did or did not complete. There are 7 different types of test, each test is labelled in the scorecard as to what type it is.

I have an existing spreadsheet that I manually enter results into, compiling the user's name from each scorecard, along with how many of each type of test they completed.

I need an automated system that will harvest the data from each scorecard and enter it into the final spreadsheet for me.

I have included the following attachments which outline my desired workflow.

Stage 1 Data: Collect the Login and Username field from each file

Stage 2 Data: count how many instances of each type (A, B, C, D, etc) of test there are. Only count instances that have a defined percentage score next to them.

Stage 3 Data: input the name, login, and instance count for each Test type into the fields highlighted in this screenshot. All the other fields are calculated fields that base their calculations off the numbers in the highlighted fields. Then create a new row for each scorecard file in the folder.

Compétences : Saisie de Données, Traitement de Données, Excel

Voir plus : write report to me, service spreadsheet, how to write reports, how to write report format, how to write a field report, excel vba expert needed write, excel vba expert needed write application, save web files excel vba, copy rename files excel vba, excel vba rank function write, merge text files excel vba, create xml files excel vba, writing xml files excel vba, compare files excel vba, create data files excel vba

Concernant l'employeur :
( 23 commentaires ) Docklands, Australia

N° du projet : #8473661

Décerné à :

dviruki

Dear Sir/Madam, I have 12 years of experience in automation of data processing and analysis using Excel and VBA . My recent projects on Freelancer include preparation of an automated equities portfolio reporting spread Plus

68 $ USD en 2 jours
(56 Commentaires)
5.1

29 freelance font une offre moyenne de $105 pour ce travail

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among Plus

150 $ USD en 3 jours
(157 Commentaires)
6.7
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Plus

200 $ USD en 3 jours
(12 Commentaires)
5.3
hwanghendra

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

100 $ USD en 2 jours
(33 Commentaires)
5.2
kevivu

Dear Sir, Done numerous similar projects in the past 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

77 $ USD en 1 jour
(33 Commentaires)
5.0
MimiFL

Hi, i m serious freelancer with 100% completion rate and i can create this macro for you. Can you please upload the rest of the pictures so i can get clear picture of what needs to be done. Also i m interested in how m Plus

50 $ USD en 1 jour
(56 Commentaires)
4.9
teeares

I have created many macros in Excel to perform various tasks. Your projects appears simple. Please attach the Excel file instead of the png and also give the template of the Excel spreadsheet into which you are enterin Plus

40 $ USD en 3 jours
(39 Commentaires)
4.6
AlexandrK1

please send the files example

167 $ USD en 3 jours
(12 Commentaires)
4.5
salih0vicx

Hello, I can help you with the project. Please check out my profile .... We can go with Excel VBA and some formulas in order to perform calculation. There would be some type of a button for you to click and have Plus

110 $ USD en 3 jours
(4 Commentaires)
4.1
surekash7096

I have the expertise in Excel and can complete the task as per your described specification, accurately. Ready to start work immediately

111 $ USD en 2 jours
(17 Commentaires)
3.9
sureshiyengar

We excel at Excel automation! Can show you samples if required. Our bid is for $72. Negotiable. The Website commission is $8. Our profile page with reviews: [url removed, login to view] (may sh Plus

80 $ USD en 3 jours
(10 Commentaires)
4.1
jnekam

A proposal has not yet been provided

100 $ USD en 4 jours
(5 Commentaires)
3.6
CARLOSHUGGINS

Hello, I'm a VBA expert with over 14 years of experience, I will be delivering a high quality an professional solution to your project, thanks in advance for considering my proposal.

89 $ USD en 2 jours
(2 Commentaires)
3.0
ifaisal

hello. i can do this for you. i have experience and expertise in excel and macros. please see my feedbacks.

55 $ USD en 1 jour
(3 Commentaires)
3.1
jatinramineni

Hi, This is Jatin. I have good knowledge on Excel Macros. I already have a macro to import the data from multiple excel workbooks. I can guarantee the delivery on the same day. Thanks & Regards, Jatin R

55 $ USD en 1 jour
(1 Commentaire)
2.0
nagyzoltan68

Hello , I would like to work on your project,. I have great experience using excel and macros / vba ,parsing and manipulating data in excel. I have had similar works, for example, one of them: a macro will copy every Plus

35 $ USD en 3 jours
(6 Commentaires)
2.0
carlosperezit

Hi Im an expert in Microsoft technologies with over tan 20 years of experience in banking sw development Regrads Carlos

55 $ USD en 3 jours
(1 Commentaire)
0.7
bshali12

Hey! Hope your having a fantastic day! My name is Shali Bala and I am a third year science & technology student at Uva Wellassa University. I believe I am the right candidate for this job because I am fluent in English Plus

111 $ USD en 2 jours
(0 Commentaires)
0.0
amitmail

Hi Greetings!! I am interested to work with you. I have worked prior on this kind of assignments. I would like to take brief info about the work as how critical is the work what exactly need to be done, after that o Plus

30 $ USD en 2 jours
(0 Commentaires)
0.0
kk3172616

Hello Sir. I'm Japanese national, native Japanese speaker. Now I'm staying in Bangladesh. I'm always working on Windows application development, using VB.NET, C#, etc. VBA is my fundamental tool. You explain Plus

111 $ USD en 3 jours
(0 Commentaires)
0.0
wenguo214

ok, very good i can help you it is very easy, but it needs some time and effort i can provide you program under acceptable price. plz check pm hope to contact with you thanks

111 $ USD en 3 jours
(0 Commentaires)
0.0