Hello,

Long time browser 1st time poster. My name is Matt.

I have been searching for days and cant find the answer to my question. Very new to Excel.

I have 2 sheets Excel 2010.

On sheet 1 the employee will put the campaign and the activity number

The campaign and activity number are in sheet 2 which will give more detailed information.

I wish to only copy and past (automatically) the FULL details of tha campaign to sheet 1 IF the campaign number AND the acitivity number match.

Can someone please point me in the right direction as I am not sure how this would be described in Excel.

Many thanks, Ma77.