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.
35 freelancers are bidding on average $261 for this job
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.
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.
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.