LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 65
Default Delete Rows from sheet 1 from values in sheet 2

Hi,

Sheet 2 has the values

A B
1 CAR BUS
2
3

Sheet 1 Has

A B
1 BUS
2 TRAIN
3 CAR
4 BIKE
5 BUS

I want to programatically select as a range CAR BUS (sheet 2) and delete
other entire rows in sheet 2

i.e

A B
1 BUS
2 CAR
3 BUS

Thanks for all future help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200911/1

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete values in sheet 2 that arre found in sheet 1 np Excel Discussion (Misc queries) 1 December 10th 09 07:21 PM
Hide rows of one sheet based on values in another sheet? Andrew Raastad Excel Programming 2 June 23rd 09 11:11 PM
Delete rows from one sheet containing deatils on the second sheet [email protected] New Users to Excel 4 September 6th 07 11:10 AM
Delete rows at end of sheet Evan Weiner Excel Discussion (Misc queries) 2 July 11th 07 08:48 PM
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows Scott Excel Worksheet Functions 0 December 13th 06 01:25 AM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"