Hi all!! I am in need of some assistance in hopes of saving some time for myself and coworkers. I have imported a report of Sales by Item from Quickbooks into excel 2010 as well as a report of Inventory by Item from Quickbooks. I was hoping the two reports would match up perfectly and I would be able to line the number of items sold in the same row as the match in the inventory on hand list and find the percentage of our inventory sold. The problem I am having is that there are hundreds of items in the inventory list that are not in the sale list which throws of my rows. I am going in manually and cutting the extra inventory item out and putting them to the side for now until later. Once I have all the items matched up by row I am sorting them into type groups and sorting these individual groups from largest to smallest and then calculating the percent. I have written a simple macro that is doing the sorting for me once they have been group by type and the formula for the percentage was simple as well so no problems there. I just need to know what function I can use to match up the names of the sold items to a perfect match of the inventory items and move the mismatches to the side or antoher sheet so I don't have to cut and paste the thousands of items manually. I have attached a sample of the sheet with some notes and would love any help at all or guidance on an easier way of doing this. Thanks sooooo much in advance!!!!
Lena
Bookmarks