I'm looking for some help to create a macro to import 3 types of csv files into an excel workbook report template "Report_Example"
The folder where the files are generated would contain the report workbook "Report_Example"
I attached a zip file containing some example data and the report template "Report_Example"
This what I would like the macro to do:
Import the 3 different file types into a 3 seperate worksheets in report template.. like so:
- CSV file name beginning with "1F" import into worksheet "1F"
- CSV file name beginning with "2F" import into worksheet "2F"
- CSV file name beginning with "MS" import into worksheet "MS"
The files are generated daily and include the date in the name.. so when the macro is run it locates any new csv files generated and appends the data into each worksheet, ie build up a database for each csv file within the workbook
The macro may be run daily or weekly so would be good to just click on a macro button to run it.
Thanks in advance for any help