I deal with this frustration all the time at work with downloading data from a website, which creates CSV raw data file that has to be saved as an excel file. When you save it in excel the data is a mess. It takes hours to reformat the data so it can be imported into the Department Reconciliation Worksheet to perform the reconciliation.
My question: Is there an efficient way to download and manipulate the raw data from the website into the format required by Department Reconciliation Spreadsheet?
Any help or ideas would be greatly appreciated.