I'm downloading a csv file form a site called enappsys by clicking on an api link in an excel spreadsheet. Once clicked the csv file will be downloaded then can be opened in excel. Ususally I will have to copy and paste this data into another worksheet. The first columns contains a bunch od datetimes that I have to sepereate into just date and time columns along with using them to perform various other functions such as vlookup. Is there anyway to automate this whole process?
Thanks