Merging Inventory Lists


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.

Recent News

Analyze PDF Files in Excel

In today’s data-driven landscape, extracting valuable information from PDF files is a common challenge. We often encounter PDFs that contain structured data we would love to analyze in Excel. Our client had a 60-page PDF that he needed answers from the data to run his...

read more

Supporting your growing business

Here’s a situation we run into with our client. Someone builds a model in Excel and it works great. Time goes by and the business grows. That single workbook gets copied for the new customer/division/business unit. Quite a bit of manual work is needed to make it work...

read more

Will Excel go away?

I was recently asked whether Excel was going away. Now, I’m not a Microsoft mind reader but… here’s why I think Excel is here for a long while. Excel is too easy to use for it to go away. Most people can create a spreadsheet that reflects their business needs. That’s...

read more