İptal Edildi

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

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).

Sample files attached.

Trying again to add files to this project so you can see what the data and report spreadsheets look like. Also:

When bidding, please specify what programming language you will use. We will need the final source code before payment is made. Bid amounts should include all required time and expenses to communicate specifics (if needed), complete all items described, testing, and the time to fix bugs. Full payment will be made upon successful completion of the project. There is no interim payment for this project and no payment will be made if the project is not completed in a timely manner. We will need a maximum of two weeks after you complete the project (but probably much less time) to try it out and check the source code before payment is made. It is understood that things seem to take more time than anticipated, so some leeway might be given on your stated timeline, but don't bid with a tight timeline. If we both agree to changes in the significant scope of the project, the bid amount and timelines can of course be adjusted. If you have not completed a project like this before, don't bid on it.


Beceriler: Excel

Daha fazlasını görün: where two lines meet, where to find some programmer, where to find programmer, where i can find a programmer, where find a programmer, what should i look for in a programmer, two lines meet, room summary, printed names, need to find programmer, need to find a programmer, need of excel programmer, i need to find a programmer, how to get to a size 0, how to get a programmer, how to find where two lines meet, how to find programmer, how to find a programmer for excel, how to find an excel programmer, how to find a c++ programmer, how to be a programmer, how can i find a programmer, get help from a programmer, found a programmer, find programmer for your app

İşveren Hakkında:
( 0 değerlendirme ) Novato, United States

Proje NO: #4418097

12 freelancers are bidding on average $277 for this job


Hello, Excel VBA expert here. Please check PM for details. Thanks!

in 7 gün içinde400$ USD
(58 Değerlendirme)

Such jobs are my daily practice. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. I plan to complete the project via Daha fazlası

in 5 gün içinde300$ USD
(40 Değerlendirme)

Expert excel developer with great experience here....Looking to work on this project.

in 3 gün içinde126$ USD
(69 Değerlendirme)

Thanks for the invitation.I propose to meet your requirement using Excel macros. Kindly provide sample files to study.

in 5 gün içinde400$ USD
(54 Değerlendirme)

we specializes only in excel application

in 2 gün içinde137$ USD
(15 Değerlendirme)

Don't be put off by the estimated time and cost. I would like to look at your sample before sharpening my pencil. Please provide a sample file. If you do so by amending your project page please let me know by PM. Ple Daha fazlası

in 10 gün içinde440$ USD
(7 Değerlendirme)

Good evening- I am an Excel guru with tons of experience working with spreadsheets and importing data. I'd love to chat and get this project rolling.

in 5 gün içinde247$ USD
(1 Değerlendirme)

Dear lungvw: I have completed projects exactly like this before: importing and processing information from multiple files. Please see my Portfolio and Feedback history for specific examples. Excel 2003 is my preferre Daha fazlası

in 30 gün içinde550$ USD
(4 Değerlendirme)

Hi We are EXCEL /VBA Expert we will like to do it,Please see PMB

in 7 gün içinde101$ USD
(3 Değerlendirme)

Hi, i can do this program for you, thanks.

in 3 gün içinde100$ USD
(2 Değerlendirme)

Ready to initiate the project and willing to deliver the task with perfection. PM

in 2 gün içinde250$ USD
(1 Değerlendirme)

I have provided solutions to this type of project several times recently. I would welcome the opportunity to work with you on this project.

in 3 gün içinde275$ USD
(0 Değerlendirme)