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.
48 freelancers are bidding on average $277 for this job
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)
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