Hi Ramesh,
Try using the code below:- This code would rename the sheets with the name
in range(A1)
Sub newsheetname()
Dim i As Integer, Newname As String
For i = 1 To ThisWorkbook.Worksheets.Count
Newname = ThisWorkbook.Worksheets(i).Range("A1").Value
ThisWorkbook.Worksheets(i
ND VBA MACROS
> Sent: Wed, November 4, 2009 10:02:44 AM
> Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name
> as sheet name
>
> Thank you so much for your help.
>
> I am afraid to tell you that, the 1st procedure "Sub Segregate_Data()
> &qu
work then.
P
From: Chanti-Hyderabad
To: MS EXCEL AND VBA MACROS
Sent: Wed, November 4, 2009 10:02:44 AM
Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as
sheet name
Thank you so much for your help.
I am afraid to tell yo
> Paul
>
>
> From: Chanti-Hyderabad
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, November 4, 2009 7:45:49 AM
> Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name
> as sheet name
>
> Thank you so much for your message
Thank you so much for your help.
I am afraid to tell you that, the 1st procedure "Sub Segregate_Data()
" is returning me an error, and the error is "Division by Zero".
Request you to do the needful
Thank you,
Ramesh
On Nov 3, 8:01 pm, Paul Schreiner wrote:
> sure,
>
> these macros should wor
From: Chanti-Hyderabad
To: MS EXCEL AND VBA MACROS
Sent: Wed, November 4, 2009 7:45:49 AM
Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as
sheet name
Thank you so much for your message:)
I agree with u, and i like the concept of keep a main database from
Thank you so much for your message:)
I agree with u, and i like the concept of keep a main database from
where we can perform all the required analysis, but in some instances,
i have to segregate the data by manager, and update the managers with
their respective details, moreover this is a continu
sheet, you can
sort each time you add a new entry.
Regards - Dave.
Date: Tue, 3 Nov 2009 18:56:31 +0530
Subject: $$Excel-Macros$$ Re: Segregate data in appropriate sheet with Name as
sheet name
From: ramesh1...@gmail.com
To: excel-macros@googlegroups.com
Hi Team,
Is there a way we can seg
Hi
I think you are saying you have many columns with headings "ramesh", "ravi"
etc and you want a macro which will create as many sheets as the number of
columns you have with the respective names and segregates the data in the
columns to respective sheets right?
It is possible.
But why do you
sure,
these macros should work.
they assume that the sheet with the data is called "Data"
and you want to copy the row from column "A" to "Z"
the second macro deletes all sheets except for "Data"..
so, be careful. if you have more sheets that you want to
keep, you'll have to modify the macro.
I
Hi Team,
>
> Is there a way we can segregate the data depending upon the name
> (column A) to different tabs.
>
> Example
> If it is a macro, and if I run it, the result would be:
>
> Sheet names: “Ramesh”, Ravi”, “Rakesh”, and “Sridhar” and each tab
> would contain the data as per the sheet name.
11 matches
Mail list logo
