Copy Rows to New Sheet if Cell Contains but to Next Blank Row

rich100

New Member
Joined
Mar 8, 2011
Messages
4
I have 100 rows of data and need to pick the rows that have an "x" in one of the cells. If the 1st cell of a row contains the "x" then that entire row needs to be added to another worksheet. I am trying to have the data automatically copy to the new worksheet but then have them fill down to the next empty row so there are no blank rows in between filled rows.
Once an "x" is placed in the box on the original sheet, the row that was copied would disappear from the new sheet. The other data rows would fill the one now vacant without any empty rows.

Thanks
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,144,660
Messages
5,725,640
Members
422,634
Latest member
YenOlmedo

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