Hey everyone!
Our company has been using a service which allows us to collection information. It outputs the data in a csv file. I would like to create canned reports for employees to run, that looks at the CSV data and does some calculations, and then gives them an output. Is this doable in excel (VBA / Macros) or more of an access thing?
There will be alot of CSV's probably around 1000 a month. The reports will have to compare data on multiple variables month to month to show increase / decrease, and trends.... think of stocks
Our company has been using a service which allows us to collection information. It outputs the data in a csv file. I would like to create canned reports for employees to run, that looks at the CSV data and does some calculations, and then gives them an output. Is this doable in excel (VBA / Macros) or more of an access thing?
There will be alot of CSV's probably around 1000 a month. The reports will have to compare data on multiple variables month to month to show increase / decrease, and trends.... think of stocks
