Completed

VBA Macro Needed to Copy Formatted Data in Excel

This project was successfully completed by ZeusMan for $250 USD in 2 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$250 - $750 USD
Completed In
2 days
Total Bids
49
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.

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online