Create multiple worksheets based on criteria from a Master Worksheet

[LedRoc]

Hi All
Looking to create multiple worksheets based on criteria from a column in a master worksheet.

The master worksheet will contain a list of items pertaining to sales information. Each row will contain info such as Product #, Model #, Price, Quantity, and most importantly salesman ID #.

Im looking for a way to create a spreadsheet for each salesman ID# and list all the info for each individual sale. I have been sorting the master worksheet by salesman ID", then copy & pasting the info to each individual worksheet. This proves to be time consuming.

Would a macro be easy to create for this or is there another way to approach this problem. Please let me know if more info is need and Ill try my best to provide it.

Thanks!

 

[Diablo II]

i would make a worksheet userform, that they can fill out, when they put there ID in, use that when whey click the button to enter the sale, the button uses that cell to find and sheet indext with that id and puts the data in the next empty cell.