# Code for Delete MATCH Rows

#### MrRajKumar

##### Active Member
Hi All.

There are 7 Sheets in my workbook.Sheet1 and Sheet2 contains Datas. I have named range Data1 [Sheet1A3:K2500], Data2 [Sheet2A3:k2500]. In Sheet3 i have a formulas for Left Lookup in A3,B3,C3,D3,E3,F3,H3,I3 and down to row 2500, that is

=IF(ISERR(OFFSET(DATA1,MATCH(\$G3,OFFSET(DATA1,0,6,ROWS(DATA1),1),0)-1,0,1,1)),OFFSET(DATA2,MATCH(\$G3,OFFSET(DATA2,0,6,ROWS(DATA2),1),0)-1,0,,1,1),OFFSET(DATA1,MATCH(\$G3,OFFSET(DATA1,0,6,ROWS(DATA1),1),0)-1,0,1,1))

This formula working perfectly. I am looking here if datas are true in Sheet3 row 3, i want to delete the Matching row from Data1 or Data2 and in Sheet3 row 3 results changed to value before save the workbook.

Eg;

Sheet3A3=1, B3=2, C3=3, D3=4, E3=5, F3=6, H3=7, J3=8, K3=9. These values i got from above formula, If this row are TRUE i want to delete the Matching row in Data1 or Data2 and replace the formula in row 3 to values. But i want to keep the below rows formulas (SheetA3:K2500).

How can i do this? I am a beginner in VBA, so please mention how to do?

Thank you
Raj

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Replies
6
Views
1K
Replies
5
Views
650
Replies
2
Views
243
Replies
0
Views
302
Replies
3
Views
337

1,191,318
Messages
5,985,950
Members
439,991
Latest member
NCWalker

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back