Thanks Marc for your reply, I have a worksheet with details of all salesmen sales achieved by article. What I want is to make a separate file will each worksheet for each salesmen and I want to do this using MACRO. Please can you help me with code....Hi !
To make your own macro, you can use an advanced filter.
To see in Excel help as in VBA help (AdvancedFilter).
to enhance my excel skills.