Hello Guys,
I just started with VBA so i am no expert. So basically i am trying to do is have a vba code that will take cell "A38" match that cell(item Code) with column(Item Code) "B13:B28" and than once it finds the matching cell record the cell value (price) on "C38" with the corresponding column (price) "E13:E28" if no value to say "for quotation". I attached a sample worksheet so you can see what i mean.
forum.ozgrid.com/index.php?attachment/68902/forum.ozgrid.com/index.php?attachment/68902/