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

[rich100]

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

 

[jmthompson]

Not certain I can help, but I know you need to provide more information
You have 100 rows of data
1- always 100 rows?
2- Let's call this sheet a

When someone enters an x in column A, you want that row removed from sheet a and moved to sheet b?
1- where do you want it on sheet b, the next available/first unused row?

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.

1- huh? Are you saying that when you move the row from sheet a, you want the rows below it to move up? and/or do you want to duplicate the row multiple times on sheet b?

 

[rich100]

On my excel sheet, each row has date ( ie cell A1 ) , machine (B1) , supply (C1)reorder #(D1), qty(E1) and "x" (F1) indicating that the supply was shipped. As each request for supplies comes in another row is added, ie A2,B2,C2,D2,E2,F2. I could have more than 100 rows depending on the requests.

On sheet B is where I want all the orders that have yet to be filled listed. I need sheet B to look at all supply orders in Sheet A and only list the rows that do not have the "x" in the shipped column (F). I do not know how to have sheet B always monitoring sheet A for just the "x" and then only showing them in order without spaces between rows.