+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prashant pawle
Sent: 08 May 2012 12:43
To: Excel Helper
Cc: prashant pawle
Subject: $$Excel-Macros$$ Macro for data sorting
Dear Experts,
Please ignore previous mail
many thanx noorain
On Tue, May 8, 2012 at 1:12 PM, NOORAIN ANSARI wrote:
> Dear Prashant,
>
> Please use below code..
>
> *Sub Data_sorting()*
> *Sheet2.Activate*
> *Cells.Select*
> *Selection.Sort Key1:=Range("E2"), Order1:=xlAscending, Header:=xlYes, _*
> *OrderCustom:=1, MatchCase:=Fal
Dear Prashant,
Please use below code..
*Sub Data_sorting()*
*Sheet2.Activate*
*Cells.Select*
*Selection.Sort Key1:=Range("E2"), Order1:=xlAscending, Header:=xlYes, _*
*OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _*
*DataOption1:=xlSortNormal*
*End Sub*
See attac
Dear Experts,
Please ignore previous mail , correct file attached here , please help on
below
Kindly advise macro to sort data by dt of opening & Macro shd run if the
range of data is changed
Thanks in advance
Regards,
Prashant
--
FORUM RULES (986+ members already BANNED for violation)
1
