Sedang Disiapkan

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.

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: 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

Tentang Majikan:
( 14 ulasan ) Washington, United States

ID Projek: #1555251

Dianugerahkan kepada:

ZeusMan

Looking forward to working with you again...

$250 USD dalam 5 hari
(83 Ulasan)
5.9

35 pekerja bebas membida secara purata $261 untuk pekerjaan ini

Teloquence

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

$250 USD dalam 5 hari
(330 Ulasan)
7.7
svet63

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

$350 USD dalam 5 hari
(80 Ulasan)
6.7
koolsidz

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

$250 USD dalam 0 hari
(172 Ulasan)
6.6
danielgpratidya

Hi, please count me in

$250 USD dalam 7 hari
(187 Ulasan)
6.5
bharanisrihari

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

$250 USD dalam 3 hari
(74 Ulasan)
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 dalam 2 hari
(30 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(61 Ulasan)
5.7
m0shimul

I am ready to start the work..

$250 USD dalam 10 hari
(29 Ulasan)
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 dalam 2 hari
(38 Ulasan)
5.3
imudita

I have done similar projects. Please see PM.

$250 USD dalam 3 hari
(31 Ulasan)
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 Lagi

$250 USD dalam 2 hari
(18 Ulasan)
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 Lagi

$250 USD dalam 2 hari
(24 Ulasan)
4.6
kakoappa

Hello, VBA expert here.

$250 USD dalam sehari
(10 Ulasan)
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 dalam 2 hari
(33 Ulasan)
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 dalam sehari
(14 Ulasan)
4.4
shagoon2u

More than 7 yrs experience.

$400 USD dalam 7 hari
(4 Ulasan)
4.1
shacoim

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

$250 USD dalam 2 hari
(10 Ulasan)
3.9
ahmedmayeen

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

$250 USD dalam 2 hari
(4 Ulasan)
3.5
cheungkc

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

$250 USD dalam 5 hari
(7 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(3 Ulasan)
2.9