This is what I am trying to do:
When the text in cell 'A2' on 'sheet 1' is equal to the text in 'column A' on 'sheet 2', paste the text from the following 10 cells in that row from 'sheet 2' into cells 'B2 through to K2' on 'sheet 1' (ie. 10 cells).
When the text in cell 'A2' on 'sheet 1' is equal to the text in 'column A' on 'sheet 2', paste the text from the following 10 cells in that row from 'sheet 2' into cells 'B2 through to K2' on 'sheet 1' (ie. 10 cells).