Hello there. I am in need of some help. I am fairly new to excel at least the VBA side of the house and I am so confused about this. I have a spreadsheet that I have to refresh daily and go over to monitor the quanties of such items. Now I want to creat a user form to be able to type in the product code and click the print button and it go find the product code and print out certain information like the locations and qty off. My table is called mismatch and I also have a pivot table showing all of the locations of each item and the error quantity of each location. Any help with the would be great.