i have two sheets with two columns 'broj' i must compare those column and if i find matching values, cells from sheet 2 copying in sheet 1. like example i have sheet 1
and sheet 2
primer.xlsm | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | broj | korisnik | banka | racun | banka1 | racun1 | banka2 | racun2 | banka3 | racun3 | ||
2 | 100253 | korisnik1 | banka1 | 11-111-11 | ||||||||
3 | 100255 | korisnik2 | banka2 | 21-11-23 | banka2 | 11-45-56 | banka3 | 77-88-44 | banka2 | 33-322-22 | ||
4 | 200345 | korisnik3 | banka3 | 23-11-23 | banka4 | 67-44-66 | banka3 | 34-55-77 | banka4 | 22-245-33 | ||
5 | 200453 | korisnik4 | banka4 | 23-22-44 | banka1 | 45-55-77 | banka1 | 24-46-776 | ||||
Sheet1 |
and sheet 2
primer.xlsm | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | broj | korisnik | banka | racun | ||
2 | 100253 | korisnik1 | banka1 | 11-111-11 | ||
3 | 100255 | korisnik2 | banka2 | 21-11-23 | ||
4 | 200345 | korisnik3 | banka3 | 23-11-23 | ||
5 | 200453 | korisnik4 | banka4 | 23-22-44 | ||
6 | 100253 | korisnik2 | banka2 | 11-45-56 | ||
7 | 100255 | korisnik4 | banka1 | 45-55-77 | ||
8 | 200345 | korisnik3 | banka4 | 67-44-66 | ||
9 | 200453 | korisnik3 | banka3 | 34-55-77 | ||
10 | 100253 | korisnik2 | banka3 | 77-88-44 | ||
11 | 100255 | korisnik2 | banka2 | 33-322-22 | ||
12 | 200345 | korisnik3 | banka4 | 22-245-33 | ||
13 | 200453 | korisnik4 | banka1 | 24-46-776 | ||
Sheet2 |