Here’s how we resolved a recent customer’s project.
Customer’s Current Situation – The client receives updated inventory lists from a variety of customers. They need to be reviewed and validated before uploading into the client ‘system. They had to first move the columns to fit, then look through the list to validate the information.
Talon’s Solution – The process was automated where they copy/pasted the information into an Excel workbook. We wrote VBA code to Import the data, allowing the user to save the layout so it can be used the next time. This improved the validation process making it easier to see any errors and improving the creation of the file to import to their system.