@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 &...
@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...
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.
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...
@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...
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...
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...
#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...
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.
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.