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' (E-Mail Removed)

Thanks in advance.

Ragavendran R

Hi Ragavendran R

Try this macro
http://www.rondebruin.nl/copy6.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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' (E-Mail Removed)
>
> Thanks in advance.
>
> Ragavendran R
>