Dear Team,
Required help on macro condition. What I am looking for :- We need to matched 4 numbers from Sheet A with Sheet B In S*heet A* Number (A1) Order_NO (B1) QTY_RECEIVED (*G1*) RECEIVED_COST_FC (*H1*) Now the *condition 1* :- Need to count total order numbers if these are matching then go for QTY_RECEIVED & RECEIVED_COST_FC if these are also matching. Then transfer (copy, paste from “Sheet A” to “result” Sheet Result :- if everything matching then from Sheet A transfer the data to “ *Result*” sheet Now the *condition 2 :- *Same as above if total number of orders didn’t match then go for the next number in “Sheet A” Result ;- N/A (Total number of orders are not matching hence go for the next number in *Sheet A)* *Now the condition 3 :- *Total number of order are matching but* QTY_RECEIVED* or *RECEIVED_COST_FC* One of shows not matching then go for the next number in “Sheet A”. Result :- N/A (here as per sheet A total *QTY_RECEIVED* or *RECEIVED_COST_FC* one of these are not matching hence go for the next number* in “Sheet A”* In Short we need to match 4 number (Mention above) if it matches then shift data from “Sheet A” to Sheet “Result” Some tips: - 01) Data heading will not be same as attached excel file. Please help Word document same as mention above, excel sheet attached Thanks & Regards, PP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Book1.xlsx
Description: MS-Excel 2007 spreadsheet
Document 1.docx
Description: MS-Word 2007 document
