• 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.

Search results

  1. K

    Sort when deactivating or leaving the sheet

    Dear All I have two sheets; Names and Data. The Data sheet is entered with inputs, but the Name field comes from using dropdown validation of NameListRng that comes from the Names sheet. Now as the Names are added in the last row in the Names sheet it needs to be sorted when i move back and...
  2. K

    Insert entirerow improvement needed [SOLVED]

    Hi I hope someone can help me with improving the following code: Explaination would be most helpful. Rgds Kieranz Sub InsertRow() Dim sClrC As String, iActvC As Integer sClrC = "D1:J1,L1,N1:O1,U1" iActvC = Range("lrnInsertCurr").Column Range("InsertRow").Select ActiveCell.Offset(-1...
  3. K

    Rank on Two Criteria

    Hi All We are doing a fun raising “Bicycle Race”! We would like to have a leaderboard to display bikers timetaken. So for purpose of example I have biker name Column; Stage Completed Column and TimeTaken column. Data is as follows: Aaa 4 5:00 Bbb 3 4.40...
Back
Top