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.
29 freelance ont fait une offre moyenne de 105 $ pour ce travail
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.
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
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