I need a macro that will populate an Excel sheet (Template) with data from another spreadsheet (Data Set).
Each row of data that's populated for a client should create and save the file with the company number as the file name and be in Excel 2007 (xlsx) format.
The sample data should produce 16 files once the macro is executed. Reference the [url removed, login to view] sample file on how it should look and save.
The data should be centered on the Template file in the areas highlighted in green.
Project is needed by 10 AM Eastern Time (less than 10 hours from now) and shouldn't take very long for someone with these skills. If you cannot accommodate this time frame please do not bid. To ensure you're not a robot, reply with the word "rush" in your bid.
Template cell C5 should contain data from Data Set column C
Template cell B6 should contain data from Data Set column D
Template cell C8 should contain data from Data Set column G & H (concatenated with a space)
Template cell C11 should contain data from Data Set column O
Template cell C14 should contain data from Data Set column J
Template cell C17 should contain data from Data Set column K (left of the first comma)
Template cell D17 should contain data from Data Set column K (2 letter State)
Template cell E17 should contain data from Data Set column K (numerical zip code)
I also have 2 more projects very similar to this one and will consider using you again if you can produce satisfactory results. This one is the smallest of the projects so it's a good test to check your work. I will be posting the next similar project which is more complex within the next 24 hours and look forward to working with the same Developer.
If you have any questions please let me know. I will choose a Programmer very soon and will pay you half of the project for a milestone and the other half once it has been tested on my side.