Can someone here guide me on how to do something? I have vendors that send price changes in an Excel format. It includes their part number and the new cost. I want to apply that new cost to my QuickBooks data. Now I export a Excel item list spreadsheet with that particular vendors data and go back and forth between the two spreadsheets getting the new cost and typing it in on the QuickBooks file. I want to be able to import the new cost into my QuickBooks Excel file by matching up the manufacturers part number with the new cost. How can I do that? Is there a software program I can buy to do this or is the function available in excel.
Bookmarks