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

    count colored cells based on conditional formatting

    OMG! This is exactly what I am looking for! A big big big thank you navic! Liked!
  2. M

    count colored cells based on conditional formatting

    Hi everyone, I have no luck searching the internet looking how to count the number of colored cells based on conditional formatting. Please see attached file for better understanding what I wanted to achieve. On column O, i wanted to count the number of red cells (overdue date) on its adjacent...
  3. M

    insert new row and copies formula from columns L:P

    That is exactly what I am looking for! Thank you so much Ajesh!
  4. M

    insert new row and copies formula from columns L:P

    I am thinking of adding this code. How do I loop (copied formula to "adjust") so when a new row is inserted, the formulas above them get copied? Range("L2:P2").Copy Range("L3:P3")
  5. M

    insert new row and copies formula from columns L:P

    Hello Ajesh! Yes there are no exclusions on that code because I don't know how to do that in VBA. I'm pasting to a normal range (not a table). I have uploaded the file for reference.
  6. M

    insert new row and copies formula from columns L:P

    I'm relatively inexperienced at VBA code and was hoping someone could help. The code below copies data from range B2:AC2 from the "Release" sheet and inserts a new row and pastes the data to the "Record" sheet. Problem is I now want to exclude L2: P2 so when it pastes to the new row inserted, it...
  7. M

    AVERAGE and SUM

    AWESOME! This solved my concern! I dont know how much I can thank you! :)
  8. M

    AVERAGE and SUM

    OMG! bosco_yip, it worked like a charm! But how do i start from row 3 all the way down? I am getting error if the cells from the columns are empty. The amount of non-blank cells from those columns may vary daily so I must define the range to infinity. PS: The blank cells contain formulas that...
  9. M

    AVERAGE and SUM

    Thanks bosco_yip. I will try it now.
  10. M

    AVERAGE and SUM

    Thanks for the insight Eloise but this is not just merely cosmetics since I am dealing with a large file with multiple tabs (daily). Attached is the actual file. I'm trying to add hours rendered (elapsed time) column on the dashboard which would also capture efficiency by dividing elapsed time...
  11. M

    AVERAGE and SUM

    Hello guys! Is there any way to get the total elapsed time without having to use helper column D? Data in column B are not sorted and may appear anywhere within the column. A blank cell means there is only 1 order. Thanks in advance!
  12. M

    delete all sheets except the first 2 and the last X amount of sheets

    Thanks much! But i have a question, is it not possible to terminate the input box after clicking cancel? Why do we have to have another box to cancel it? And for clicking ok with an empty string, can we have a personalized message rather than the default "We found a problem with this formula..."...
  13. M

    macro to copy and rename workbook to today's date plus 1 day if existing

    Sub NewPage() On Error GoTo EH Sheets("Master").Visible = True Sheets("Master").Copy After:=Worksheets(Worksheets.Count) NewPageName = Format(Date, "mmdd") ActiveWindow.ActiveSheet.Name = NewPageName Sheets("Master").Visible = False Range("B3").Select Exit Sub EH: Sheets("Master").Visible =...
  14. M

    macro to copy and rename workbook to today's date plus 1 day if existing

    Sub NewPage() Sheets("Master").Visible = True Sheets("Master").Copy After:=Worksheets(Worksheets.Count) NewPageName = Format(Date, "mmdd") ActiveWindow.ActiveSheet.Name = NewPageName Sheets("Master").Visible = False Range("B3").Select End Sub This code will copy my MASTER sheet, rename it to...
  15. M

    delete all sheets except the first 2 and the last X amount of sheets

    thanks so much shrivallabha! it worked, however, if i click cancel on the input box, the execution doesn't stop and the whole sheets get deleted except the first two and when i click ok without any input, i want the error message to be personalized like "please input the last amount of sheets to...
  16. M

    delete all sheets except the first 2 and the last X amount of sheets

    userform can be useful but i want a command button where it will delete all sheets except the first two and the last x amount of sheets. The first two sheets are very vital (Dashboard - visible and Master - hidden) and the rest sheets vary (daily tracker). At the end of the month, these sheets...
  17. M

    delete all sheets except the first 2 and the last X amount of sheets

    How do I delete all sheets except the first 2 sheets and the last X amount of sheets? I also want to have a pop-up message asking the user how many last sheets they don't want to get deleted. Note: 2nd sheet is hidden - so i don't want to delete the first visible, the 2nd (which is hidden) and...
  18. M

    average from unique cell values

    How do i get the pass rate without using the data on column H to J? Please see attached file. Thanks in advance!
  19. M

    VBA to get the difference between two timestamps

    Hi, I'm just starting to learn VBA. Can you help with the codes I need to use so column L (starting from L3) will auto-calculate (L3-C3) and so on and so forth. Currently I have codes on my worksheet to automatically create timestamps based on data entered on columns B and J and column L...
  20. M

    time elapsed when data is entered between two cells

    Hi, I would like Excel to measure the amount of time(in minutes) elapsed when data is entered between two cells( Columns B and E). I don't want previous time to update especially when they update values on columns B or anything that prevents them from manipulating the data. I just need to track...
Back
Top