Xiaojiang
Registered User

how to split the data with multiple sheet to multiple workbook based on coloum




if sheet 1 has many data and also given the name chetan raj amit
and sheet 2 has given in pivot table who is linked in sheet1
and sheet 3 has given in chart who is linked in sheet1

then what should i do in this case
simple save as and delete the data

i need 3 workbook
1 chetan workbook with 3 sheets( 1 data, 2 pivot table, 3 chart)
2 raj workbook with 3 sheets ( 1 data, 2 pivot table, 3 chart)
3 amit workbook 3 sheets ( 1 data, 2 pivot table, 3 chart)


so can u help me
of this matter