In Progress

VBA Macro Needed to Copy Formatted Data in Excel

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: Excel, Visual Basic

See more: vba with, formats in excel, vba right, vba for, right vba, in vba, master excel, vba excel macro, to copy, save to excel, reports in excel, report from excel, macro, Macro vba, macro excel, macro + excel, excel-to-csv, excel vba macro, excel to vba, Excel to CSV, excel reports, Excel report, Excel Macro VBA, data visual, csv data

About the Employer:
( 14 reviews ) Washington, United States

Project ID: #1522531

Awarded to:

ZeusMan

Looking forward to working with you...

$250 USD in 2 days
(75 Reviews)
5.9

48 freelancers are bidding on average $277 for this job

svet63

VBA developer since 1997. All your requests are quite feasible. Can do. Regards, Svet.

$450 USD in 4 days
(78 Reviews)
6.8
bharanisrihari

Hello, Excel VBA expert here. I've done similar projects successfully. Please check PM for details. Thanks!

$250 USD in 3 days
(67 Reviews)
6.5
Teloquence

Excel expert at your service. Check your inbox for details.

$250 USD in 4 days
(149 Reviews)
6.4
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$250 USD in 3 days
(91 Reviews)
6.1
danielgpratidya

I can do everything you can imagine with Ms. XL

$250 USD in 1 day
(108 Reviews)
6.0
vserv

10+ years experience with Excel. Please see your messages. Thanks

$250 USD in 3 days
(70 Reviews)
5.9
srinichal

I can deliver the macro to your specs

$325 USD in 5 days
(33 Reviews)
5.8
Krusche

Hello. Creating Macro in Excel is our core specialization. Please check our reviews and examples in your PMB.

$360 USD in 4 days
(30 Reviews)
5.7
northwolves

Ready to [url removed, login to view] PMB please.

$250 USD in 2 days
(57 Reviews)
5.2
MDavidCrompton

Hello, I have completed many Excel VBA projects, please see my feedback. I understand exactly what you require and can deliver it correctly and quickly. Sample in PM. I hope to work on this. David

$250 USD in 3 days
(23 Reviews)
4.9
Nhcuong

Dear Sir/Madam, I can do it. Please check my solution in PMB. Looking forward to working with you, Cuong NH

$250 USD in 2 days
(29 Reviews)
4.9
barundebnath

Hi, I am expert VBA programmer. I very much confident about this job. Thanks

$250 USD in 2 days
(11 Reviews)
4.6
MichalBayer

Please read my private message. Thanks!

$250 USD in 2 days
(10 Reviews)
4.6
chriskerpini

More than 10 years experience in Excel-VBA. Please check your PMB.

$250 USD in 3 days
(12 Reviews)
4.5
pyazlm

I can provide an application in Excel VBA.

$250 USD in 5 days
(32 Reviews)
4.5
KellogITSolution

Hello Me an Ms-Excel Expert working on MS-Excel & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Excel Projects and can provide u sample copi More

$250 USD in 2 days
(16 Reviews)
4.4
naveenvarthaan

Hi, Project almost completed and ready to be delivered. Please check the attached sample (this spreadsheet which i developed recently processes 3 *.csv files and generates reports. Please check INBOX for file) If More

$250 USD in 2 days
(18 Reviews)
4.4
microk

Expert here.. Please check PM..

$250 USD in 2 days
(23 Reviews)
4.3
srdas2012

We are Expert in VB and Excel can do your [url removed, login to view] see Private Message.

$250 USD in 7 days
(13 Reviews)
4.2
muthumuni

...........#####... "KINDLY FOLLOW MY MASSAGE & FEEL REAL DIFFERENT HERE" ...##### ..............

$250 USD in 1 day
(12 Reviews)
4.1