Re: $$Excel-Macros$$ Need Macro to make multiple sheets

Its working well Thanx!! On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI wrote: > Dear Deepak, > > Please use below code... > > Sub N_spilit_Worksheet() > Dim i As Long > Dim k As Long > Dim j As Long > Dim rng As Range > Dim sh As Worksheet > On Error Resume Next > Set sh = ThisWorkbook.Workshee

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

Hi Its counts are not coming correct Pls check on this. On Thu, Jul 5, 2012 at 7:16 PM, Deepak Rawat wrote: > Its working well > > Thanx!! > > > On Thu, Jul 5, 2012 at 7:12 PM, NOORAIN ANSARI > wrote: > >> Dear Deepak, >> >> Please use below code... >> >> Sub N_spilit_Worksheet() >> Dim i As

Re: $$Excel-Macros$$ Need Macro to make multiple sheets

: excel-macros Subject: $$Excel-Macros$$ Need Macro to make multiple sheets Hi, I want a macro for attached sheet what i need exactly I have a consolidated data of muliple city. I want to make diiferent sheets citywise and shteet name should be of city. Regards, Deepak Rawat -- FORUM RULES (986