VBA code to copy from another workbook using multiple cell values

Hi all,

I have this code which searches for the value in F6 in another workbook and returns the relevant row from that workbook.

This might be an elementary question, but say I want to add another criteria , ie, I want the user to enter a value into cell F6 and, for example, F7, what changes would I need to make for this to happen?

It needs to be done as just searching by F6 doesn't differentiate between duplicates, and I need the user to also enter a name, again for example, in F7 to locate the exact row required.

Thanks.

Please Login or Register  to view this content.

Hi,

Knew I'd forgotten something important...

F7 would match with Column F

Thanks,

That works perfectly, thankyou.

The one thing that I may need to change, it now comes up with the message box about there being a large amount of data on the clipboard and do I want to keep it (after pasting into sh1).

How do I set this to automatically say no?