@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.
@Marc L
Thanks a lot for your time spent towards my thread. Finally I couldn’t supply the required information in my first post. If possible post your lighting fast code as per the initial post. Don’t consider the real work book as its having more mess.
thanks again for your help.
Yes
Yes #4 is same as real worksheet.
Just for your Idea, I shared the real workbook which is damn slow. As far as my initial post request of move data to another sheet works all versions of excel.
I am just modifying with no tables of real worksheets similar to the initial post attachment...
Boss,
The columns A to Q are filled without blank then the remaining columns get filled with their formulas. this is the way A to Q and the Column 1 to LastCol are not blank same.
'Transferred Sum' is always blank in A to Q except for J as it is just the sum of R to LastCol.
In the last attachment, I have transferred all the completed rows of data to the respective sheet. that is why only a few rows of data are there.
Note that Transferred Sum always has blanks from Column A to till consumption Starts. So whenever J6 to LastRow(Starts with the letter "Transferred")...
Attached here is the sample sheet with sales and free sample transferred and transferred sum sales and free samples added for your understanding.
Yes, No need included 'Transfered Sum' MsgBox
Okay, in this case, we can transfer only the row which has filled all data from column 1 to the last...
Boss, I will make the respective sheets available before initiating the code.
Transfered Sum "Sales"
Transfered Sum "Free Sample"
Transfered Sum "Modified"
Transfered Sum "Rejected"
Transfered Sum "Storage"
All of the above should be placed in rows 6 to 10 in the Production Sheet. it is the sum...
Dear Excel Genius,
I have an excel workbook having the sheets "Production", "Sales", and "Free Sample". Production Sheet J6 to LastRow have a data validation list (Sales, FreeSample, Modified, Rejected, Storage)
I need a VBA Code to move data whenever I run the code to the respective sheets...
It is working like a magic boss.
without knowing this simple trick I tried Calculate, Do Events, and pause one second to calculate before export. but nothing has resulted.