Use of Loop Function for extracting data from Master sheet and creating seperate files

Hi Everyone,

I am looking for help to automate a report. Let me explain what exactly I want.

There is master sheet in which we have data in around 1.2 lakhs rows and in column A to M. In column I there are around more then 300 vendor names given and i want to extract the data vendor wise in a separate tab then save that file with same vendor name in a different folder. I have used the below coding which gives me what exactly i want but its very difficult to use this again and again for more then 300 vendors. its good only for few data but currently the data is in more then one lakh rows.

Please Login or Register  to view this content.

Therefore, I want if some can help me for coding of loop through which i can extract the data vendor wise and create a separate files with same vendor naming convention in different folder. if this work then i will get more then 300 separate files in different folder.

Please help me asap as its urgent.

Let me know in case if something is not clear.

Thanks.
Ankit Jain

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



( I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

hi there,

maybe you can post the excel file so we can have a look?
the criteria of your filter is all the time the same, or is changing with the names of all your vendors? If you have 300 then you want 300 of files in that folder?

am I right?

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Please Login or Register  to view this content.