Match (2 criteria) then copy paste

I want to match my database with 2 criteria, in columns AB and AC with the range columns A and B.
If they match, it should copy and paste the corresponding columns from my database to the range. It should copy and paste when match, like lets say AD6 in D10 and AE6 in E10.
I want the other formulas in the columns A:F to be intact, I want it to just paste the times in the matching name and date.

I made this up but its rubbish.
Anyone a batter macro? Thanks a lot.


test2 - Copy.xlsm

Please Login or Register  to view this content.

copied from the forumrules.

http://www.excelforum.com/forum-rule...rum-rules.html

. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Select your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:


copy to clipboard
your code here ...
and here ...
and hereYou can also type the code tags in manually if you prefer. For more information about these and other tags, click here.