Hi all, I would like to write a VBA code so that, to run through row “2” and where find the description “Item code” should prepare the formula below descriptions
“Closing stock quant”: .Formula = "=VLOOKUP(RC[10],'[Closingstock.xlsx]Sheet1'!R4C1:R5000C32,25,0)"
“Cons.quant”: .Formula =...