I have a retail parts store that uses Quickbooks POS software for it's inventory. The inventory file consists of approximately 20 thousand items that are exported to an Excel file that will be updated from price updates from my vendors.
I need to automate this into a program or macro to reduce the input time. I use Excell 2003. I would like this to combine/merge and update all sheets data to one sheet.