• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter column grater than 7 days ageing

Vijayarc ... hmm? ... focus!
1) You sent many empty sheets ... challenge to test! = cannot do!
2) There were NO Do_It-macro ... not good all!
3) About previous case ... those sheets headers are not fixed!
You cannot EVER get any filtered row!
( if M- or N-columns ... are empty - not my challenge! )
4) If check those days from ... empty columns then ...
when any of those would be over 30?
5) As many times written, that Do_It-macro should use as written!
6) Any ideas .. of something 'high priority' or whatever?
 
hi Vletm

please find attached your Do_it file.
rows to highlight in red , if days grater than
30 days in M column
 

Attachments

  • Do_it.xlsm
    433 KB · Views: 2
Vijayarc
Did You even tried to read my previous reply?
After that You sent ... interesting two-file cases ... oh no ... WOW!
Have You eaten something today or what?
I did that >30 days already with my file,
but that won't help ... me ... nor ... neither You,
if You keep both eyes closed!
ps. which is greater 24 or 28?
 
hi Vletm,

really i can't find any code in previous post to highlight grater than 30
in the above Do-it file i added column grater than 30 days. pls help.

interesting two-file cases ... oh no ... WOW! - pls help that too
my new manager hitting my head for daily new requirement cases
 
Vijayarc
the last time: Did You even tried to read my previous reply?

3) About previous case ... those sheets headers are not fixed!
You cannot EVER get any filtered row!


I did that >30 days already with my file, (my file is here)

even question like which is greater 24 or 28?
seems to be challenge ... hmm?
> maybe Your new manager will understand better <
Keep on skipping or focus!
 
sorry vletm!! pls don't take it bad

1.which is greater 24 or 28? - 28 is grater
2.I did that >30 days already with my file, (my file is here) - i can't find any attached file in your reply even in all today reply
3.About previous case ... those sheets headers are not fixed! - each sheet have different column filters, so header will not same ,
4. please attached your Do_it code with rows highlight in red grater than 30 days for only M column
 
Vijayarc
I won't ask that question anymore ... no answer!
1) ..but in other place, You wrote that 24 ... hmm?
2) Did You notice those ( ... ) ... no!
3) Challenge
... if I-column data isn't same kind (including those keywords) and
... M & N-columns don't have even those days and so on ...
then ALWAYS NOTHING! as in Your #18 Reply -file.
... if this seems to be mess ... and I don't like mess!
 
Hi vletm

finally it works for condition highlight colour the row grater then 30 days

thanks vletm for your support !!!!


Code:
 If Not .AutoFilterMode Then .Range("AA1:AA" & y_max).AutoFilter
  y_max = .UsedRange.Rows(.UsedRange.Rows.Count).Row
  .Range("AA:AA").ClearContents
  .Range("AA1") = "aa"
  For y = 2 To y_max
  RH = Empty
  chk_i = .Cells(y, 9)
  If chk_i = "WIP - LOB" Or chk_i = "Rejected" Then
  Err.Clear
  chk_m = .Cells(y, 13)
  If Left(chk_m, 10) = "NotStarted" Then
  cut_m = WorksheetFunction.Find(" - ", chk_m, 1)
  If Err.Number = 0 Then
  chk_m = Mid(chk_m, cut_m + 3)
  cut_m = WorksheetFunction.Find(" ", chk_m, 1)
  If Err.Number = 0 Then
  chk_m = Left(chk_m, cut_m - 1)
  If chk_m > 7 Then RH = 1
  If chk_m > 14 Then
  .Cells(y, 13).EntireRow.Interior.ColorIndex = 22
  End If
  End If
  End If
  End If
  Err.Clear
  chk_n = .Cells(y, 13)
  If Left(chk_n, 3) = "WIP" Then
  cut_n = WorksheetFunction.Find(" - ", chk_n, 1)
  If Err.Number = 0 Then
  chk_n = Mid(chk_n, cut_n + 3)
  cut_n = WorksheetFunction.Find(" ", chk_n, 1)
  If Err.Number = 0 Then
  chk_n = Left(chk_n, cut_n - 1)
  If chk_n > 7 Then RH = 1
  If chk_n > 30 Then
  .Cells(y, 13).EntireRow.Interior.Color = 22
  End If
  End If
  End If
  End If
  End If
  .Cells(y, 27) = RH
  Next y
 
  .Range("AA1:AA" & y_max).AutoFilter Field:=1, Criteria1:="<>"
  End With
 
Sorry for usee your name there,

Please can you help on my ageing tread.. sooy for repeatedly chasing . My job depends on ly
Hoping on you, expecting you favourable reply

Thanks you once again for success in filter treaf
 
want to find only the days number and paste in ageing sheet in column C,D,E,F
You get max days number (two kind).
hmm .. other four ... hmm? I've no idea!
Cannot You copy & paste needed values,
after You'll find out ... what?
 
Sorry sir,

I have 2 condition
1..to find max days in 17 lob -- works great
2. There is 4 columns highlight in green " Credit, Refdata2, KYC, Refdata3"
U find max in this 4 columns also

But I want only number of days in this each 4 columns .as per above image

After I will total the 5 columns days (your Max column,, Credit, Refdata2, KYC, Refdata3)

Screen Shot 2018-08-12 at 3.48.45 PM.png

Capture.PNG
 
sorry to ask repeat sorry

I tried to answer your questions ,

What would mean 'only' for You? I ask password of file to learn macro code, because the file is macro password enabled, that it sir,

Still same ... same, no answer - I clarified on my 42 reply,
hmm .. other four ... hmm? I've no idea! I want only days of 4 green columns as per 42 reply
Cannot You copy & paste needed values, - yes sir,i can copy paste
after You'll find out ... what? -I will total of all five columns as per image in reply 42

please help to find only days number of green columns
 
sir,
I hope I answered all your questions, please help to find only days number of green columns
 
Last edited by a moderator:
Sir
this is how I will find total ageing for 5 columns ,
please help me sir. one day to go to submit the result

untitled1.png

untitl2ed.png

Result:
---------
Capt1ure.PNG
 
vletm sir,

if it wont complete this ageing report, tomorrow, I will be in very bad situation, please help before it, i beg your pardon
 
sure marc sir, I am accepting your suggestion

but pls undertand , there is no time. kindly help for one last time,
at least for one column . I will try remaining columns
 
Back
Top