LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I creat a macro to delete the first 20 cell characters Bobo-ack Excel Worksheet Functions 5 April 20th 07 03:00 AM
creat a macro to save a copy with different file name yrndtn Excel Discussion (Misc queries) 2 September 8th 06 01:14 PM
Creat dsanita Excel Discussion (Misc queries) 0 July 25th 06 10:01 PM
How can I creat NYExcel Excel Discussion (Misc queries) 2 April 17th 06 04:39 PM
creat a macro to look for a file Kelly****** Excel Discussion (Misc queries) 1 January 2nd 05 09:24 AM


All times are GMT +1. The time now is 11:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"