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

    Match row and column header and copy data

    Respected Sir, My bad, thank you so much for this simplified basic code. It works perfectly. Highly appreciate the immediate support on this query, with regards, thomas
  2. T

    Match row and column header and copy data

    Respected Sirs, There are two worksheets in the attached workbook, one is "Entry" and the other is "Final". There is input data in worksheet "Entry" from range C86 to D161 and this range can vary based on selection in the other data fields marked in grey and has not been shown. There are two...
  3. T

    Start first quarter and dynamically based on selected date

    Respected Sir, This is brilliant. Thank you very much for this solution. Yes, you are right, some of my expected results are not aligned with the data provided. I will apply this in the actual data. Really appreciate all the guidance and support, with regards, thomas
  4. T

    Start first quarter and dynamically based on selected date

    Respected Sir, My apologies i overlooked the month before saving the sheet2 - the selected month was supposed to be July - and hence the Q1 in this case should be starting from July. The lower rows were examples for different selected months - in this case if the selected month is Feb, the Q1...
  5. T

    Start first quarter and dynamically based on selected date

    Respected Sir, The formula solution you provided worked perfectly on the actual data. Thank you so much for this great support. We have now a similar case for the six quarters but now the change required is to start the quarter based on calendar quarter. So if the selected date is in February...
  6. T

    Start first quarter and dynamically based on selected date

    Respected Sir, This worked perfectly for the sample data. Thank you so very much, I will try this on the actual data and get back to you for any concern. Highly appreciate your guidance and support, with regards, thomas
  7. T

    Start first quarter and dynamically based on selected date

    sorry, the above reply got clicked without completion The date of the first Q1 can be considered as 09/01/2022. Thank you very much once again, The dates above mentioned are in format mm/dd/yyyy. with regards, thomas
  8. T

    Start first quarter and dynamically based on selected date

    Respected Sir, The last date if 12th August(this is the input date from user B2 in the sheet), then Q1 should be from next month based on the date of 9th September. So in this example case - Dates 09/09/2022 - Q1 10/12/2022 - Q1 01/06/2023 - Q2 and following. Yes the date of the first dat of
  9. T

    Start first quarter and dynamically based on selected date

    Respected Sir, Thank you very much for your support. The quarters start on any given date. it is not set to first or fifteenth of the months, for example if the last date was 12th August (consider August end of month), and the quarter start date was 9th September then the first quarter would...
  10. T

    Start first quarter and dynamically based on selected date

    Respected Sirs, We need a formula to populate quarters dynamically on range of dates based on an input date for the next six quarters. Kindly find attached a sample file with the input and requirement For example if the input date is 09/15/2022 (B2) and the range of dates start with...
  11. T

    Congratulations Marc L sir for his 5,000 + helps

    Respected Sir, Many congratulations on 5000+help to the forum. Thank you very much for being there. with regards, thomas
  12. T

    Subscript out of range error

    Respected Sir, Thank you very much for this revised code and your support. very much appreciated always, with regards, thomas
  13. T

    Subscript out of range error

    Respected Sir, sorry for the late reply, not well. The drop down currently was created using data validation with reference to input to values in data list tab (J11:J16), as these drop drowns also change the image (K11:K16) named range (Dimage) in index and other tabs. The activation of...
  14. T

    Subscript out of range error

    Respected Sir, Correct sir, what I meant is on the departments were, MEN, ANN, CAT, SAD and LOY (Worksheets) and the change event would trigger the corresponding sheets for each department for example department MEN, which included MEN, data, data list and Index to be visible. Thank you very...
  15. T

    Subscript out of range error

    Respected Sir, Thank you for your guidance, I thought about the logic once again and it seems this will not work to have a drop down selection as well as password login at the same time working, as was the case initially. We needed to check the possibility of restricting user through the login...
  16. T

    Subscript out of range error

    Respected Sir, My blunders, and apologies, yes now I removed all the code lines containing visible in the change event. Thank you for this guidance. The new change event code looks like this. Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Then Exit...
  17. T

    Subscript out of range error

    Respected Sir, I found a code which gives all the sheet tabs in data validation in cell A2 of Index tab, but do not know how to have the visible option working with this. Private Sub Worksheet_Activate() If ActiveCell.Address = "$A$2" Then ActiveCell.Offset(-1).Select End If End Sub...
  18. T

    Subscript out of range error

    Respected Sir, Thank you for this guidance and support, So according to the Open event, just respecting the Logic, remove any codeline which contains Visible as again it's so weird to hide / unhide any sheet as all the job is yet done via the Open event ! In the Open event, each time a sheet...
  19. T

    Subscript out of range error

    Respected Sir, Thank you for all the support on this automation and sorry for bothering again on this. I need your guidance and support again on this. All the codes provided are working perfectly, but the user needs to have the work sheet event change based on drop down selection to activate...
  20. T

    Subscript out of range error

    Respected Sir, Again amazing. Thank you so much for this code. This works perfectly. Very mcuh appreciated, with regards, thomas
  21. T

    Subscript out of range error

    Respected Sirs, Sorry to come back again on this. There is a new exception require now. How can we exclude Usernames MEN and SAD from the username a password login routine. These two users should be able to access the file without a login and password prompt and access all tabs. Thank you...
  22. T

    Update cell in copy

    Respected Sir, Brilliant, this is exactly what was required. Thank you so much for this guidance and your support, very much appreciated always, with regards, thomas
  23. T

    Update cell in copy

    Respected Sirs, I was trying to copy sheets and rename them using the below code. Sub CopySheets() Dim ws As Worksheet, sh As Worksheet Dim Rws As Long, rng As Range, c As Range Set sh = Sheets("Overview") Set ws = Sheets("CA") With sh Rws = .Cells(Rows.Count...
  24. T

    Subscript out of range error

    Respected Sir, Thank you very much once again, I cleared all the codes within Sheet1 module. Yes agreed the drop down, is duplicated and I will use it differently for the picture selection and for calculation of other sheets without the visibility requirement. Much appreciated. with regards...
  25. T

    Subscript out of range error

    Respected Sir, The revised code worked perfectly. Thank you for your guidance and support on this. Sir, If the drop down allocation for visible sheets needs to be used how can the change event code be changed to ensure the drop down has only visible sheets. Ca n the username be used as a...
Back
Top