In support of this Thread:
http://www.excelfox.com/forum/showthread.php/2364-Delete-row
http://www.excelfox.com/forum/showth...364-Delete-row

_____ Workbook: BasketOrder..xlsx ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I J K L M N O P Q
1 NSE EQ ACC NA NA NA 0 1 0 BUY MARKET NA CLI MIS DAY WC5758 NA
2 NSE EQ ADANIPORTS NA NA NA 0 1 0 SELL MARKET NA CLI MIS DAY WC5758 NA
3 NSE EQ AMBUJACEM NA NA NA 0 1 0 BUY MARKET NA CLI MIS DAY WC5758 NA
4 NSE EQ ASIANPAINT NA NA NA 0 1 0 BUY MARKET NA CLI MIS DAY WC5758 NA
5 NSE EQ AXISBANK NA NA NA 0 1 0 BUY MARKET NA CLI MIS DAY WC5758 NA
6 NSE EQ BANKBARODA NA NA NA 0 1 0 SELL MARKET NA CLI MIS DAY WC5758 NA
7
Worksheet: BasketOrder. (1)


_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E F G H I
1 Exchange Symbol Series/Expiry Open High Low Prev Close LTP
2 NSE ADANIPORTS EQ 409 409 398.65 407.2 402
3 NSE ABC EQ 216.2 219.15 215.15 215.8 218
4 NSE ASIANPAINT EQ 1409 1441.95 1401.85 1404.2 1441.3
5 NSE AXISBANK EQ 732.9 739.3 728.15 727.45 733.65
6 NSE BANKBARODA EQ 118.8 119.15 114.7 118.35 115.25
7 NSE BHARTIARTL EQ 342.95 348.5 337.4 342.55 343.05
8
Worksheet: 1-Sheet1


The Process:
If cells of column C of basketorder.xlsx matches with cells of column B of 1.xlsx then delete the entire row of 1.xlsx(here entire row means the cells which matches delete that entire row)

_____ Workbook: BasketOrder..xlsx ( Using Excel 2007 32 bit )
NSE EQ ACC NA NA
NSE EQ ADANIPORTS NA NA
NSE EQ AMBUJACEM NA NA
NSE EQ ASIANPAINT NA NA
NSE EQ AXISBANK NA NA
NSE EQ BANKBARODA NA NA
Worksheet: BasketOrder. (1)

_____ Workbook: 1.xls ( Using Excel 2007 32 bit )
Exchange Symbol Series/Expiry Open High Low Prev Close LTP
NSE ADANIPORTS EQ 409 409 398.65 407.2 402
NSE ABC EQ 216.2 219.15 215.15 215.8 218
NSE ASIANPAINT EQ 1409 1441.95 1401.85 1404.2 1441.3
NSE AXISBANK EQ 732.9 739.3 728.15 727.45 733.65
NSE BANKBARODA EQ 118.8 119.15 114.7 118.35 115.25
NSE BHARTIARTL EQ 342.95 348.5 337.4 342.55 343.05
Worksheet: 1-Sheet1