VBA Macro Needed to Copy Formatted Data in Excel 2
$250-750 USD
Færdiggjort
Slået op cirka 12 år siden
$250-750 USD
Betales ved levering
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.
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.
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 bid without any additional fees.
Regards!
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.
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 copies if you so desire. U can expect quality work in time.
Thanks
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.
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 for you in $200.
Regards
Faisal