I have a simple file with two worksheets in. In the first worksheet (a product list) are a number of columns, including
Product Code and
Product Description. In the second worksheet (dispatches in January), I have
Product Code. I need to insert a new column with the associated
Product Description field completed based on the relevant line from the first worksheet.
I'm sure this is very easy, but its not something I've done before.