I am having two datatables in File1.xlsx (11.7 KB) having sheets
And the required output sheet
Here, if in ‘Main’ column MatchingCode and SQFT = in ‘input’ column MatchingCode and SqFt
Then assign all the values of column Color Code and FinalSqFt (of input sheet) to RM Color Code and Req. Qty (of main sheet) and repeat all the column values like “MAP and RPO” of main to the added extra lines.
If no match found then be the lines as it is.