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

Recent content by Anbuselvam K

  1. A

    MsgBox Required depends on selection

    @rlv01 The code is working perfectly. thanks a lot!
  2. A

    MsgBox Required depends on selection

    Only the date will be more than one row not all the three values.
  3. A

    MsgBox Required depends on selection

    @rlv01 Thanks for the code and the explanation of my mistakes. I added your code and checked. it is showing "No cost details were found. " But the selected cells D13 intersect value has the cost details in RM Cost sheet row 8. See the snapshot below. I need a msg box row 7 heading &...
  4. A

    MsgBox Required depends on selection

    @BobBridges I added both the line of code and got an error. see below the snapshot.
  5. A

    MsgBox Required depends on selection

    @BobBridges Thanks a lot for your time and efforts towards my post. Your modified and suggested code perfectly shows the MsgBox row2 & row3 & Col2. As we did not declare the code range, it triggers the code wherever the values are selected in the Sheet instead of C8:CX13. We need to add the...
  6. A

    MsgBox Required depends on selection

    Also, If I select two cells then it will show the Msg Box. I think the code I wrote is entirely wrong or some important thing is missing. Anyway, guide me on how to finish this code to learn further whenever your time permits.
  7. A

    MsgBox Required depends on selection

    Yes, you are correct. RM Cost is the details of each RM Purchase cell values C8:CX13. This sheet was prepared by me and frequently my company owner will visit and check the RM Purchase sheet. Note always RM Cost will be in hidden mode to avoid others opening and editing or deleting them. So to...
  8. A

    MsgBox Required depends on selection

    @BobBridges First, Thanks a lot for your reply. Yes, Correct C8:CX13 as after the column "CX" is not the price. No, If the operator selects "CU11" then it has to look at the intersect values of the same sheet "CU2" and "CU3" and the date of "B11" to the RM Cost sheet Columns 2, 3, and 1...
  9. A

    MsgBox Required depends on selection

    Dear Excel Genius I have RM01 to RM100 cost in RM Purchase sheet like the below image. Target cells are C8:CX13 When I select any of one cell in the target range it has to show the msgbox from the sheet RM Cost from column A to lastcol For example, If I select the sheet RM Purchase cell...
  10. A

    Move data to another sheet with few conditions

    It is working great Boss, Thanks a lot for your support.
  11. A

    Move data to another sheet with few conditions

    Boss, The MsgBox is just to cross-check how many rows we entered data and how many of them going to transfer to the destination. So if the transfer works only for the selected cell rows, then no need MsgBox as I know what I selected. Also, only the first time I transfer huge rows of data, then...
  12. A

    Move data to another sheet with few conditions

    I meant I need an easy understanding of code, not a complex or tricky one.
  13. A

    Move data to another sheet with few conditions

    #16 With these conditions as my tricky faster way can't work as it is with your real workbook Noted Boss. then I would post something closer to a classic way like any VBA beginner can give it a try, easier to mod for another context than the specific initial post attachment … I am okay with...
  14. A

    Move data to another sheet with few conditions

    Please note that I will transfer all the existing data very carefully after filled Yes, Boss, Please don't use any dictionary code. I need a code which can easily understand and is transferable for future changes. The above heading 5th row is not in our calculation area. So I did not mention it.
  15. A

    Move data to another sheet with few conditions

    Boss, The above heading 5th row is not in our calculation area. So I did not mention it. Yes, Boss, The MsgBox is correct. As there are blank cells in 'Floor/Flat Number' In the first run of code, I will transfer 77+22=99 then I will get the blank to be filled for the second run.
Back
Top