Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-29-2017, 05:35 AM
Seiquo Seiquo is offline Delete rows with certain values (plural) Windows 7 64bit Delete rows with certain values (plural) Office 2010 64bit
Novice
Delete rows with certain values (plural)
 
Join Date: Jun 2017
Posts: 4
Seiquo is on a distinguished road
Default Delete rows with certain values (plural)


Good morning forum,

What would be the VBA code to delete the rows that contain in column A one of the values listed in another spreadsheet, in column A too?

Workbook1, sheet1: 1200 rows, with a number in column A.

Workbook2, sheet1: 43 rows, with a number in column A. The numbers don't follow and are not in order (e.g. - in A2, A3, A4 : 45366, 43801, 43471, 46514...).

In workbook1, I need to delete the rows that contain in column A a number listed in Workbook2.

And cherry on top, the list in workbook2 may increase from month to month...

I know how to write the code to delete a row that contains a certain value, but I have no idea how to do it with a list of values.

Thank you so much in advance to anyone who can help me.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Get all rows based on input values from a list soolsen Excel 1 03-27-2016 08:11 PM
Delete rows with certain values (plural) Looping through rows and copy cell values to another worksheet get4hari Excel Programming 1 10-02-2015 04:51 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
Delete rows with certain values (plural) Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Delete rows with certain values (plural) Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:20 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft