Hi folks,

I need a help on Excel macro. I have a spreadsheet which called sheet1 and
has thousands of records and group by departments. I want to create a macro
which can move the same departments records to the new sheet and rename the
sheet to the department name. Could anyone show me the code? Any help will
be appreciated?

Thanks in advance.

Tim.