Everyday I receive a report in a .csv format, and on a daily basis I will copy the data into an "INPUT" tab on my spread sheet. The data on this input tab keeps on growing every day with the information and I will import this data by:
- Clicking the last row on the "INPUT" tab
- Get external text data
- Import the CSV with ; as my delimiter and inputting the data from row 2 on wards
- Format the text to font Calibri 8pt
The CSV files that come in all have a date incrementing naming convention list so:
20130826_Summary_Report.csv 20130827_Summary_Report.csv 20130828_Summary_Report.csv
Were probably looking at about 5000 lines of data a day, and while it isn't the most time consuming task, we're looking at ways to simplify the process.
Is there any way I can create a macro which will grab the latest .csv file out of a folder and import the data using the process above automatically?