Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match two excel spread sheet using Macro
I have one excel sheet, on sheet1 and sheet2 as following...
sheet1 has 1200 records ColumnA ColumnB ColumnC 123 xxxx YYY 222 xxxx xxxxx sheet2 has 1000 records ColumnA ColumnB ColumnC 123 xxxx YYY 234 xxxx XXXXX 222 xxx xxxxx if ColumnA of sheet1 and sheet2 are not match, like my example has 234, then I would this row moved to sheet1 of column F, G, H. Thanks. Lillian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match two excel spread sheet using Macro
Hi Lillian,
Need a bit of confirmation. What rows do you want the data moved to? Just starting at top row and all the moved rows one under the other in columns F, G and H or do they have to be placed relative to the last matched row? Also, does columns F, G and H have column headers or can column headers be inserted? When you say 'moved', do you mean that they have to be cut from the original list or just copied? Regards, OssieMac |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Match two excel spread sheet using Macro
OssieMac,
Thank you for help me out, acutally I want be like this Sheet1 has 1000 records it has SSN Name IPadress 123 linda 1.1.1.1 222 john 2.2.2.2 Sheet2 has 1200 records it has SSN Name IPaddress 123 linda 1.1.1.1 222 john 2.2.2.2 333 bob 3.3.3.3 if A2 of sheet1 and sheet2 match then copy sheet1 of columA, columnB, ColumnC to sheet2 of column F.G.H, so it would look like this on sheet2 SSN Name IPaddress ColumF ColumG ColumH 123 linda 1.1.1.1 123 linda 1.1.1.1 222 john 2.2.2.2 222 john 2.2.2.2 333 bob 3.3.3.3 that way I can see SSN 333 is not in the sheet1 I can see the match and not match both on same sheet 2. "OssieMac" wrote: Hi Lillian, Need a bit of confirmation. What rows do you want the data moved to? Just starting at top row and all the moved rows one under the other in columns F, G and H or do they have to be placed relative to the last matched row? Also, does columns F, G and H have column headers or can column headers be inserted? When you say 'moved', do you mean that they have to be cut from the original list or just copied? Regards, OssieMac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match two excel spread sheet using macro | Excel Programming | |||
Compare two excel spread sheet with macro | Excel Programming | |||
Created another spread sheet if SSN is not match | Excel Programming | |||
can I clean old excel data format with macro on funny spread sheet | Excel Programming | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions |