• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create multiple worksheet based on filtering a row from main data sheet

riyazremani

New Member
Hi All:

I have a database sheets including sales achieved by all salesmen.

I want to make a macro to create multiple sheets for each salesman in a separate file
 

Attachments

  • Test for Chandoo.xlsx
    77.4 KB · Views: 2

Hi !

To make your own macro, you can use an advanced filter.
To see in Excel help as in VBA help (AdvancedFilter).
 
Hi !

To make your own macro, you can use an advanced filter.
To see in Excel help as in VBA help (AdvancedFilter).
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....
 

First, activate Macro Recorder.
Create a new workbook, use an advanced filter (easy as explained in help)
to first create salesmen list without duplicate.
Then for each salesman, you can use an advanced filter to copy data …
Stop Macro recorder : you have a code base …

If you are more confortable with filters, you can use them too …
 


Once you generate the beginning of your need,
post the code (between code tags) here and explain your issue …

 
Back
Top