Select ros that contain specific value in column along with any blank cells below in same column to cut to new workbook

zigojacko

New Member
Joined
Dec 7, 2012
Messages
2
To save a lot of time, I'd like to come up with a way to select all rows that contain a certain cell value in column D plus every blank cell in the same column below. I then want to cut all these rows and paste them into a new workbook.

As an example, my data could look like (I have highlighted red the data that I wish to cut from sheet):-

ABCDEF
A HeaderB HeaderC HeaderD HeaderE HeaderF Header
123simplefdbdfbdfgbdg
123simpledfsdfdsghsd
123

configurabledfgsdgsdgsds
123simpleolihill'ph'olib
123

configurablegfjfgjggfjfgjfg
123



ghkghjkg
123



dsgsdgsd
123



fdgdsgd
123



dsgsdgsd
123



sdgsdfgsd
123



sdfsafs
123simplesdfsdfssfsafsa
123simplesafassfasfsaf
123simplesafasfasfsafsafsafsa
123

configurablesfasfsasafasfas
123



dfgdfhdf
123



fdhgdf
123simplegdsgsdgscdgdghdf
123

configurablesdgsdgsddfgdgdf
123



dsgsdgds
123



gdfgdsg
123



sdgsdgsdg
123



sdgsdgsd
123



gsdgsdgg
123

configurabledgdgddgdfsgsdfg
123



fdgdfgdfg
123



dfgdfgdfg
123



dfgdfg
123



dfgdfg
123



dfgdfg
123



dfgdfgdf
123



gdfgdfgdf
123simplefgfdgdsfggdfgdfg
123

configurabledsfgsdfgdsfdfgdfgdfg
123

configurablegdfsgdfgdfgfdgfd
123

configurabledsfgsdfgsdfgdfgdfg
123



gdfgdfgdfg
123



gdfgdf
123



fdgdfgdf
123



gdfgdfgdg
123simplefhdfhfhdfgdf
123simplegfjhgkjjhdgsdgdfg
123

configurablesdgsdgsdfgdfs
123



fgdsgdfg
123



sdfsdfsd
123



gsdfgfds
123



dgfdsgdsf
123



dsfsdgsdg

<tbody>
</tbody>


I'm not entirely sure if there is a formula that can achieve this? But I'd be so grateful if anyone can provide the quickest way to achieve this.

Should say rows in title instead of ros, apologies I didn't spot the typo before I posted (please could this be amended, I could not see the option to edit myself).
 
Last edited:

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,705
Members
414,401
Latest member
grenona2020

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top