Export Excel Data Coming from Several Directoires, Import to a Report

Budget $50 - $500 USD
Bids 12
Average Bid $277

We need a program that with the click of a button extracts similar data from several identical Excel spreadsheets (2003 SP3), located in several user-specified directories, and imports that information into a similarly looking but summarized Excel spreadsheet report. From there, the user simply saves and/or prints the report from Excel. Basically, the report will summarize three lines of data from each spreadsheet. Each subsequent record (i.e., individual spreadsheet) of data will be placed under the previous one in the report and the records imported will be in alphabetical order (by Last Name). The spreadsheets are uniquely named to avoid extracting other files found in these subdirectories. See sample spreadsheet and sample report spreadsheet.

The spreadsheets have already been designed. The spreadsheet report will contain the same headings and first line of data under the headings. However, some headings and data will not be used and some of the headings and corresponding data are in a different position on the report. Last names are bolded on the report. The report could end up being 1 page long or it could be many pages long.
1) The latest two lines of "notes" for each spreadsheet will need to be imported directly under the main data. These lines come from the "Notes" section of the spreadsheet which contains several lines of data, and the program will need to find and import only the latest (lowest) two lines that have notes in them.
2) None of this should be case-sensitive.
3) Ensure that the page numbers are on the bottom center and are of small font size so that ideally 10 records of data can be shown on each page.
4) The border lines that currently show up on page 2 need to be fixed. There seems to be a bold line that shows up at the bottom when printing. I am not sure why or how to get rid of it, so your help on that is requested.
5) If the cels for the note fields on the report are not merged, the data may extend out resulting in extra pages printed out. We don't want that to happen but welcome any alternate spreadsheet fix.
6) Any other suggestions from an experienced programmer are welcome. I would like this to work in the latest working version of Excel as well as Excel 2003 SP3. We may have users with different versions of Excel.

The program should include, at a minimum, settings where the user can specify and save:
1) The directories the report will draw from. There should be room to specify at least three directories to look in, and the program should look in any sub-directories of the directories specified (perhaps by option).
2) The name format of the files to be extracted. The files will be in the format "Lastname, Firstname Policytype Co NB App Summary ... .xls" and the program must search for all files containing what I just quoted including files with longer filenames due to extra characters. The first four parameters in the filename (Lastname, Firstname, Policytype, and Co could be anything, but NB App Summary will be in every spreadsheet. Notice the parameters are separated by spaces. However, I would like an extra check which warns the user about how many files, in the subdirectories specified, contain the letters "NB" but were not imported because they didn't meet the extra characteristics (see top of sample report).

Post a Project Like This

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • johnwlee Profile Picture

    johnwlee

    Exeter,  United Kingdom

    Principal analyst/programmer with 15+ years experience providing MS Excel/Word/Access/VBA solutions

    Data Processing, Excel, Microsoft Access, and Microsoft

  • charmw Profile Picture

    charmw

    Tucson,  United States

    EDUCATION -CompTIA A+ Certified Professional IT Technician -Associate of Applied Science, Data Processing -Certificate of Achievement, Information Sciences and Technology COMPUTER LANGUAGES -Visual Basic for Applications -JavaScript -HTML -Many others EXPERIENCE -Developed Excel tools ---Automated processing with multiple files ---Complex calculations ---Workflow management ---Text processing ---Report formatting ---User Interface design -Set up and troubleshooting of computer networks -Maintained multi-user, multitasking system software -Managed multi-user security for an inte rnet site -Developed educational tools and presentations -Provided resources for others as part of Help Desk team -Solved complex and escalated problems -Data Entry: 70+ wpm, 99% accuracy

    PHP, Perl, ASP, and C Programming

  • bharanisrihari Profile Picture

    bharanisrihari

    Sydney,  Australia

    Hello, Warm Greetings! I'm a Software Engineer with excellent experience in Excel & Word Application Development using Visual Basic for Applications (VBA). Please invite me for any Excel & Word Application/Macro development using VBA. Please contact me for any sample works or references. I look forward to providing my professional services to you. Best Regards

    XML, Visual Basic, System Admin, and Project Management

  • deepbluetech Profile Picture

    deepbluetech

    BANGALORE,  India

    I am an individual freelancer with more than 10 years of Office automation and Software programming experience. My areas of expertise include Excel Dashboards, Excel Macros, Excel Formulas and Office data Management. I have qualified in the US / UK English exams.

    Visual Basic, Graphic Design, Banner Design, and Windows Desktop

  • sharly001 Profile Picture

    sharly001

    Dhaka,  Bangladesh

    ENHANCED PERFORMANCE AND GREATER PRODUCTION: I am a designer and presenter. Being an Engineer, I love to do designs and present in an eye-catching way. What type of services do you want? # Powerpoint presentation # Powtoon animated presentation # Prezi presentation # Pitch deck # Sales presentation # E-learning material or course (using Adobe Captivate) # Workshop/ seminar/ webinar # Infographics design # Sales presentation for websites or email marketing # Visio diagram # Template making (word/ powerpoint/ publisher) etc. # Logo design # Graphics design # User-Interface design # Banner design # Brochure design # Flyer design etc. WHY SHOULD EMPLOYER CHOOSE ME? I love to work and finish with perfection. Everyone knows 'Man is mortal', so if I do anything that you find wrong, then please feel free to tell me. I would love to fix that and make you satisfied. It is not going to be similar every time, so if you think you need any variation in the project price and time, then let me know. I will say once again, I'm determined in time period and perfection. Thank you for reading. Please be honest every time and Allah must help you. **************************

    Visual Basic, Graphic Design, Copywriting, and Internet Marketing

  • srdas2012 Profile Picture

    srdas2012

    chennai,  India

    We are experts in VB.net, VB, VB6, C#, ASP.Net, Visual Foxpro Programming, Back End Access, SQL, MySQL, XML, Excel, CSV with more than 10 Years of experience. We have expertise in Multimedia graphics Programmes for Maya (3d Modelling,Animation), 3d Max ,Z-Brush and Photo shop with more than 10 Years of experience. We have experts & professional translators in Hindi, Bengali, Tamil from & to English. Our motto for every customer/client/project is importance, delivery and maintaining High Quality Standard in the shortest time Possible.

    PHP, ASP, XML, and Visual Basic

  • vikashgadia Profile Picture

    vikashgadia

    KOLKATA,  India

    ITS MY PASSION TO WORK IN EXCEL. WE CAN DO ANY THING AND EVERY THING IN EXCEL.. WE CAN GUARANTEE THE FASTEST DELIVERY OF YOUR PROJECT OTHER WE WILL TAKE ONLY FREELANCER'S COMMISSION FOR THE PROJECT. APPLICATION DEVELOPED ARE EMAILING FROM EXCEL. SMS FROM EXCEL TRANSFERRING DATA TO SERVER FROM EXCEL. PDF CREATION CERTIFICATE PRINTING. INVENTORY INVOICING SALEFORCE ETC..

    Visual Basic, Data Processing, Accounting, and Excel

  • JScottArnold Profile Picture

    JScottArnold

    Chicago,  United States

    I am a young professional with 3 and a half years internal consulting experience with the technical background to moot. I specialize in data analytics and can also create presentations/excel workbooks to support any and all analyses.

    Visual Basic, Data Processing, Data Entry, and Excel

  • FLinCanada Profile Picture

    FLinCanada

    Vanier,  Canada

    Many years of experience in all aspects of development, business analysis, and project delivery.

    XML, Visual Basic, .NET, and Proofreading

  • nagybatonyi Profile Picture

    nagybatonyi

    Budapest,  Hungary

    University degree in economy and mathemathics, 30 years of system design and programming in more languages, recently 15 years Excel/VBA experience in office automation.

    Visual Basic, Excel, PDF, and Word