I have a list of sku's in a sheet named "SKU's" and need vba code to generate an inventory report with two columns, SKU and Quantity. Basically I need the code to go through the list of sku's in sheet one (there are 10000 of them, all in the first column). Then generate a report from the raw data telling me how many of each number there are. The second sheet in the excel file is named "Report" Thanks in advance for the help, I am just learning VBA.