hi all,

i have one Excel sheet contains 35 worksheets ( all are formatted ) now
i need to copy each workbook and i have to make a new excel sheet with
the individual name ( say sum,sub,mul,div these are all workbooks name
then i should be saved as same name(or sum_new something like that) for
New excel sheets) .

Currently im doing all these works by manual (Right click then select
new book then make a copy and then im saving as respective filename) .i
have to do the same daily .so can anyone help me in this ....

U can contact me thro'

Thanks in advance.

Ragavendran R