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 ?