Excel 2007 How To Reference A Seperate Cell In WS1 From A Common Cell In WS2
- by Bob Sampson
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.
Thank you