In Progress

VBA Macro Needed to Copy Formatted Data in Excel 2

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: #1555251

Awarded to:

ZeusMan

Looking forward to working with you again...

$250 USD in 5 days
(83 Reviews)
5.9

35 freelancers are bidding on average $261 for this job

Teloquence

Excel expert at your service. Consider it done. check your PM.

$250 USD in 5 days
(330 Reviews)
7.7
svet63

VBA developer since 1997. Can do. Regards, Svet.

$350 USD in 5 days
(80 Reviews)
6.7
koolsidz

Excel Whizzzzz here ;) Please see PMB for more details.

$250 USD in 0 days
(172 Reviews)
6.6
danielgpratidya

Hi, please count me in

$250 USD in 7 days
(187 Reviews)
6.5
bharanisrihari

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

$250 USD in 3 days
(74 Reviews)
6.5
Krusche

Hello. We are a Team of professionals developing MS Access\Excel applications based on the VBA programming. Assume high quality work with a precise attention to details. Check your inbox for examples.

$250 USD in 2 days
(30 Reviews)
5.6
nagybatonyi

Such jobs are my daily practice. If you send me a sample source file and the required Excel layout I'll make a free pilot conversion for you. Further use of macros, fixing of bugs and minor changes are included in the More

$250 USD in 3 days
(61 Reviews)
5.7
m0shimul

I am ready to start the work..

$250 USD in 10 days
(29 Reviews)
5.7
Pichart

I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. Your project here is not much difficult for me. I give you more detail in PMB.

$250 USD in 2 days
(38 Reviews)
5.3
imudita

I have done similar projects. Please see PM.

$250 USD in 3 days
(31 Reviews)
4.9
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
(18 Reviews)
4.5
naveenvarthaan

Hi, I completed your project. Completed a sample output for your project. You can also view my past works at my website [url removed, login to view] Please look into your INBOX for additional message More

$250 USD in 2 days
(24 Reviews)
4.6
kakoappa

Hello, VBA expert here.

$250 USD in 1 day
(10 Reviews)
4.7
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$250 USD in 2 days
(33 Reviews)
4.3
himanshuhc

Hi, I am attaching a working sample for you in PMB to go through, which is based on my understanding of your requirements. Kindly go through it once to see if it interests you.

$250 USD in 1 day
(14 Reviews)
4.4
shagoon2u

More than 7 yrs experience.

$400 USD in 7 days
(4 Reviews)
4.1
shacoim

***Very Important***Please check PM***Demo videos attached***

$250 USD in 2 days
(10 Reviews)
3.9
ahmedmayeen

Hi, I dropped my formal bid in the private message, please refer to that. Regards, Mayeen

$250 USD in 2 days
(4 Reviews)
3.5
cheungkc

Hi Can you provide some sample so that we can ascertain a more realistic quote please?

$250 USD in 5 days
(7 Reviews)
3.2
ifaisal

Hello I can do this for you, I have experience and expertise in Excel macros. I can do it quickly and accurately and you do not have to make any payment until you are completely satisfied. Also I can do this More

$250 USD in 3 days
(3 Reviews)
2.9