@ NARAYANK991 & SirJB7
Hello Ninjas,
It is very kind both of you to respond this.
i can wait sir.
Since i clarified some questions arise by SirJB7 recently, it is better to go with him.
@SirJB7
Hello sir,
Thank you for going through this complexity.
In work sheet i explain a term super seed, this is the main reason for all of this.
http://www.2shared.com/file/nJO6jq8b/prob2.html
sir you can also compare this logic to that i have uploaded before in document...
Hello Sir,
@SirJB7
Here i explain it.
http://www.2shared.com/file/dTAkQoaQ/prob2.html
@NARAYANK991
I have no problem at all to wait for getting help from Ninjas.
2.Yes sir,
there are columns I with dates and column K will not have "X" . These rows included in the sort .
3. Col A is for reference there is no link in sorting, it may exclude.
if there are several rows , say row 7 , 13 , 17 and 19 , which have "YES" in columns D and E they pushed up...
@ NARAYANK991
Hello sir,
i confirmed you what you ask,
Before that i want to tell something.
In this workbook new rows also added to these existing rows.
1.Sorting of data will take place only for those rows which do not have an "X" in column K & below selected date value of Col I (or...
Respected Ninjas,
I started a project two & half month ago based on sorting & also ask your help & get it from ninjas.
But i could not solve it as i have no idea what to do.
So, here i ask it again.
In my uploaded file want a macro or it may be conditional formatting that sort the data...
Hello Sir,
Sub ReorderRows()
Dim xSelect As Range
Dim BRange As Range
Dim CRange As Range
Dim c As Range
Dim firstAddress As String
Dim TimeStamp As Double
Dim DTable As Range
Dim CutRow As Range
TimeStamp = Cells(ActiveCell.Row, "G").Value
Set DTable = Selection.CurrentRegion...
Hello sir,
could you help to sort out this thing for last time.
what to do if the discontinuous data ranges have less date values in G col, As if there is tie in condition then min date value will go up to order.
sir i upload a worksheet.
http://www.2shared.com/file/8ckVr-6J/11a.html
In it suppose i enter data upto SL 4 i.e. to A8 cell, Now i come to know after some time that some data available to me & i enter it.Now the problem arise as this code does not help to move the cell up satisfying the...
Sorry sir for adding extra condition.It is for last time.
With ActiveSheet.AutoFilter.Sort
.SortFields.Clear
.SortFields.Add Key:=Range _
("G1"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
.Apply
End With
Problem with this code is it sorted the values...
hello sir,
problem seems to be much more difficult than i anticipate.
Relating to above post, code below
'Filter down to just the relevant info based on col G
ActiveSheet.Range("A1").AutoFilter Field:=7, Criteria1:= _
"<=" & TimeStamp
ActiveSheet.Range("A1").AutoFilter Field:=11...