View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John John is offline
external usenet poster
 
Posts: 2,069
Default Pls help for creat a Macro....

sample:
location number product
4 100600 A
4 100600 A
5 103200 A
6 103500 A
6 103500 A
11 106600 B
15 106600 A
18 119200 A
20 119200 B
8 103200 A
9 103800 A
19 105000 B
13 105000 B

what I need is: lookup at columns A and B, if number is same and location is
same then do nothing. if the number is same and the location is different,
then copy that row range like (A7-C7 and A8-C8) to G7 and G8. check sample
below:
location number product
4 100600 A
4 100600 A
5 103200 A
6 103500 A
6 103500 A
11 106600 B 11 106600 B
15 106600 A 15 106600 A
18 119200 A 18 119200 A
20 119200 B 20 119200 B
8 103200 A
9 103800 A
19 105000 B 19 105000 B
13 105000 B 13 105000 B