VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

**Darrellcoholic** · 05-30-2014, 10:19 AM

Hello,

I am new to VBA and will like to seek help in writing a macro.
I have got a set of data in a workbook with Sheet 1 range A1 to K373 and a range of data in Sheet 2 ranging from A1 to A30. What I will like to do is to have a VBA code to loop through all the cells in Sheet 1 column C and check which are the cells which value matches those in Sheet 2. Those that matches in Sheet 1 will have the entire row deleted. I have come out with the following codes but it does not work and hope to have someone here to guide me through.

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 05-30-2014, 10:33 AM

Please use code tags when posting.

Maybe:

Please Login or Register  to view this content.

**Darrellcoholic** · 05-31-2014, 10:22 AM

Hey John,

Got it. Thank you so much, it worked!

**JOHN H. DAVIS** · 06-02-2014, 06:15 AM

You're welcome. Glad to help out and thanks for the feedback. Please comply with Forum Rule No. 9.

9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.

VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

Re: VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

Re: VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

Re: VBA Code to Delete Rows of Data if Cells Contain the Same Value From Another Sheet

Thread Information

Users Browsing this Thread

Similar Threads

Changing code from deleting rows to cut/paste rows into another sheet and delete blank row

[SOLVED] Delete rows with #N/A values on my sheet using VBA code

[SOLVED] Code to quickly delete rows in sheet

Code to delete rows containing names from a list on another sheet

[SOLVED] Code to delete rows and column cells that have formulas in.

Bookmarks

Bookmarks

Posting Permissions