We are seeking a skilled freelancer to develop a tool that enables us to upload 50-100 similar Excel spreadsheets and outputs a single, reformatted Excel sheet. The tool should be user-friendly and efficient, ensuring data integrity and accuracy during the consolidation process. Ideally, you will have experience with Excel automation and data manipulation to create a seamless solution for our needs.

Project Details:

1. our financial service company receives spreadsheets from other companies with 30-50 fields

2. we could receive 50-100 spreadsheets a week with very similar data, but formatted differently

3. i want to build a tool that has a Master Template, then be able to upload various spreadsheets that data can be placed in the correct cells. for example In the Master Template we show City Name in cell "G", but in other sheets City could be in another cell.

4 additionally, the name of the City for example New York could be spelled out or could be abbreviated like NY, NYC, New York City,, etc,,, so we would want

5. we understand there will be exceptions, therefore we want a tool that standardizes 75-80% and the exceptions we can go into the tool at a later time and add the exception into the sheet.

---------------------------------------------------------------------------

Some notes -

-LSP A provides multiple lenders (B, C) in one bid sheet.

-Lender N, O, P, Q sheets are notoriously difficult to work with, and one-offs. Would love to include them in the program but its not 100 percent necessary in my opinion if it drives price up drastically.

-LSP A, Lender F, Lender G, Lender H, Lender M are >50% of the loan volume we see most months

Interface:

Mapping: