VBA Macro Needed to Copy Formatted Data in Excel 2

IN PROGRESS
Bids
37
Avg Bid (USD)
$260
Project Budget (USD)
$250 - $750

Project Description:
We require a macro that can parse and loop through CSV data and place the result in the right spots in an existing workbook.

We have a workbook with 2 sheets in it. The first sheet (the output sheet) shows a formatted data report and pulls the raw data from the second sheet (the input sheet). We currently paste each new data set by hand into the input sheet so it formats correctly on the output sheet. We have to run this manual process 10 times on 10 data sets to get 10 reports.

We want to be able to paste one larger, comma delimited data set to a master input sheet and create a macro that runs through that data by looking at an ID column, copies the rows to the right place on the existing input sheet, takes the resulting formatted data on the output sheet and copies the formatted report so it gets its own new sheet. The macro would repeat the process until all the IDs in the CSV data have been processed. This would mean pasting 10 data sets all at once and still getting 10 reports.

We’d then like excel to prompt for a ‘Save As’ and, if possible, pre-populate a file name based on the CSV data used.

Skills required:
Excel, Visual Basic
Hire slowbot
Project posted by:
slowbot United States
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 350
in 5 days
Hire bharanisrihari
$ 250
in 3 days
$ 250
in 0 days
$ 250
in 5 days
$ 250
in 2 days
$ 250
in 7 days
Hire nagybatonyi
$ 250
in 3 days
$ 250
in 5 days
$ 250
in 10 days
$ 250
in 3 days