I have two workbooks, one is WB1 and second is WB2.With VBA I want to copy specific cells based on a IF condition from WB2 and double paste to WB1. Also I want to add some defined numbers into WB1. It should look like this:
WB2 WB1
A B C D E F A B C
11 12 13 <-existing numbers 22 23 25
22 23 25 406 405 806
22 23 25 405 406 502
WB2 WB1
A B C D E F A B C
11 12 13 <-existing numbers 22 23 25
22 23 25 406 405 806
22 23 25 405 406 502