Need a macro to copy all rows with a matching field to a different worksheet
I have a list of employees with a Business Unit code such as 4001. I need a macro or vba code that will go through the worksheet and copy all rows with the same business code to the adjacent worksheet starting at the first blank row. Is that possible? I have attached a short demo spreadsheet.