Matching 2 fields snd then pasting the line

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.

Many thanks for your reply.

Attached as instructed.

i would like to enter info into Sheet 1 D7 and E7.

Excel would look at Sheet 2 find the corresponding line and then paste that into sheet 1, F7 to K7

Hope that makes sense.

Thank you v much.

Hi Arlette,

Yep, Quite comfortable with VBA and Macros. Well, I say that. lol.

thanks i will try that aswell. i think I am better with VBa etc. Thanks very much though.

Originally Posted by Marcol

Try this workbook
Data in Cells D7:E7
in F7

Please Login or Register  to view this content.

Drag Across to K7 then down as required.

[EDIT]
This might be a bit more robust

Please Login or Register  to view this content.

Hello,

Many thanks for those options. i would like to see if i can do this using VBA / Macros. How would I do this ?

Thanks

Matt.