Hi guys, I was wondering if anyone could help me write a macro to do the following. I have an inventory where one selects an item in column A(from a predefined range) and then puts in a serial number in column B. I want to create a macro that I can run at the end of inputting all the items and corresponding serial numbers that will take the items to another sheet and sort them by item and then serial number underneath each item. I have it setup to do that right now with formulas but it takes forever to run as I input new data into inventory sheet. With this new sheet i have set up dependant data validation for other sheets where as one inputs an item, he only has a couple serial numbers to choose from. Any help would be greatly appreciated. Thanks
Bookmarks