• 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


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

Split data into multiple workbook

Ameen Siyali

New Member
My file has two tabs, summary and data tab. i have to split the data as per different ranks(eg :Manager wise) in the data tab into multiple workbooks along with the summary tab. below are the screenshot of both sample tabs. In summary tab contains formula and picking the numbers from Data tab . so i need to split the data tab based on the B column (Manager) along with summary tab.. can someone help me with the code for it ?




Excel Ninja
Ameen Siyali
As a new Memeber,
You have just read Forum Rules - especially -- How to get the Best Results at Chandoo.org
Please, reread al least that part again and continue as there have given ideas.