Here i have attached my sample sheet & this report generating by our system.. in this excel sheet first sheet is normal data & second sheet is my requesting data. i need a macro to do bellow things..
01. need to inset one column after column "J" (Qty). so it will be column "K".
02.add "Pend Ord" text to K2 cell.
03.Column "D" to "I" row data need match with same columns above. if something match, that matching all the rows column "J" values need to sum & display in same row column "K".( my English is very bad so it's really difficult to explain. so pls check my sample u can understand what i want to say.)
ex-
my sample sheet K4 cell is empty because there is no matching data rows above.
my sample sheet K8 cell is 40 because there are one matching data rows above & that row column "J" value is 40.
my sample sheet K9 cell is 100 because there are two matching data rows above & that rows column "J" values are 40+60
pls make macro for this..thanks in advance..
Bookmarks