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

    Macro for creating a Table

    @vletm Sorry for delay in response due to my ill-health. i had tried some thing based on the support/ideas provided by you earlier (stripchart). but end up with error in if statement. Attaching the file for your review please. Regards Ashok
  2. A

    Macro for creating a Table

    @vletm , @Marc L Sorry all, I am bit confused, I will upload the proper file and need some time. Regards Ashok
  3. A

    Macro for creating a Table

    Sir, checked the output and found correct, especially Sl.No 8 & 9. I am attaching the simplified file with logic for your review. Regards Ashok
  4. A

    Macro for creating a Table

    Sir, In Strip Chart, Top Levels shall be one for any Stretch i.e. from A to B only one code will be there(i.e. top layer will be shown). But here, The hindrances for any particular stretch may contain one or more. (i.e. From A to B, one (or) Multiple Hindrance may be there) Note: The Hindrance...
  5. A

    Macro for creating a Table

    Sir, I am bit confused how to use strip chart for this. Can you explain is this can be done through strip chart. Regards Ashok
  6. A

    Macro for creating a Table

    thanks for reply, same as above, the logic is the hindrance should be same from point f to G or Point G to point H. (as A&B or A&C or B&C or B&D or individual A or B or C or D ...)
  7. A

    Macro for creating a Table

    @vletm Hi Sir, Good evening and Thanks for your response. I am preparing the same manually. the procedure i am adopting is as follows. 1) as My road starts from 128850, i checked the status at the starting chainage. thus the road from 128850 to 129000 is clear from hindrances and so...
  8. A

    Macro for creating a Table

    Dear Sir, I am working in a road project which starts at Km 128850 to Km 272571, which contains obstructions / hindrances in some strips on Left Hand Side "LHS" or Right Hand Side "RHS". The type of Hindrances are 1. LAQBalance 9.18% 2. Non payment 3. Structure obstructions 4. Trees...
  9. A

    Copy from a worksheet and paste to another worksheet

    Hi, May be i didn't explained clearly. In work sheet named "bar chart" i have data in range C1:UFX4 I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart". Brachart ----> Highway Strip Chart C1:BA4 C6:BA9 BB1:CZ4...
  10. A

    Copy from a worksheet and paste to another worksheet

    Hi, Attached the file with data. Thanks Ashok
  11. A

    Copy from a worksheet and paste to another worksheet

    Hi, In work sheet named "bar chart" i have data in range C1:UFX4 I have to paste special the values in the above range to following ranges in worksheet named "Highway Strip Chart". C6:BA9 C16:BA19 C26:BA29 C36:BA39 ..... upto... C2826:BA2829 uploaded the sample file for your reference...
  12. A

    Merge of Adjacent Columns having same values

    @vletm It worked. Thanks once again. Ashok
  13. A

    Merge of Adjacent Columns having same values

    Hi, I am using a macro (Found in internet) to merge the adjacent cells having same values. Working fine except it is merging even the cells are blank. I need to skip the blank cells (without merging). Attached the file for reference. Thanks Ashok
  14. A

    Please help with value look up and match from two tables

    @Shan Li ok, now you want to lookup the the data range. Your data is having same values in column"A" with different values in corresponding columns. what EXACTLY are you wanted to do ??? what "return value" to be placed in Column J? Ask the question in proper section if you need VBA solution.
  15. A

    Problem with Custom Validation for Date with Multiple Criteria

    @Shabana checked your file and few questions. My understandings are > Machines K1 to K7 will produce X no of products day. > All machines will not work on holidays. > Orders will be allotted to machines based on their availability. > Any machine will be allotted with another order after...
  16. A

    I'm trying to hide columns in excel when no conditional highlighting is present in the column

    @bts1969 Option Explicit Sub show_hide_columns_color() Dim cell As Range Dim button_color As Long For Each cell In Range("H2:J18") 'Change range to suit If Not cell.Interior.Color = 65535 Then If Columns(cell.Column).EntireColumn.Hidden Then Columns(cell.Column).EntireColumn.Hidden = False...
  17. A

    Please help with value look up and match from two tables

    @Shan Li First upload the workbook instead of image for better help from members. Attached work book with formula for you.
  18. A

    Error in showing user form

    @NARAYANK991 it worked. thanks for your reply. Ashok.
  19. A

    Error in showing user form

    @NARAYANK991 thanks for your reply. I had corrected the mistakes, but the following code is giving mistake. PrivateSub CommandButton1_Click() rfi.Show EndSub Uploaded the modified file. Can you please check. Note: I am using Excel 2016 Thanks Ashok
  20. A

    Error in showing user form

    Dear sir, I am trying to enter data with the help of user form named "RFI". I had prepared the user form and created a command button named "RUN" to show the user form "RFI" and assigned following code. Private Sub CommandButton1_Click() rfiuserform.Show End Sub & While clicking the...
  21. A

    Set value of second cell based on first cell in a range.

    @NARAYANK991 Thnak you very much, Ashok.
  22. A

    Set value of second cell based on first cell in a range.

    @NARAYANK991 While using the macro "FillDown", Remaining cells are filled with value"0" (for ex. A1, B1:B3, C1:C6,...) But using the macro "Fillup", remaining cells are NOT filled with value "0". Can you modify the macro "FillDown" so that remaining cells are not filled with "0". Thanks Ashok
  23. A

    Set value of second cell based on first cell in a range.

    @NARAYANK991 Thanks a lot. Ashok
  24. A

    Set value of second cell based on first cell in a range.

    @Narayan It worked great. Trying to understand the macro. Meanwhile, i need to to fill values in reverse order for another condition. If cell (A2) value is 1 then range A1:A2 values has to be 1. Likewise for columns B:L, Attached the output file for your reference. Thanks for your help. Ashok.
  25. A

    Set value of second cell based on first cell in a range.

    @Narayan attached the output file for your reference. Thanks Ashok
Back
Top