Hi Experts! Novice here...
I have a daily CSV export (Email by country.csv) with the column names. Everyday I manually paste the new data into an XLS document (Email.xlsx).
I was wondering if I can automate this process by dropping the CSV into a folder and when I open the XLS, have a script (macro) run that checks a folder and imports csv data below the existing data in the XLS.
The other catch is that the data is on the second tab of the Excel sheet.
I'm running Office Excel 2007.
Thanks in advanced for any assistance!