Auto-copy rows from one tab to another based on cell value Closed

Question

Hello! 

I'm really hoping this works to get a response because I am stumped. I've read a lot of sites and lot of similar posts but nothing seems to work quite right.

I have an Excel workbook for tracking quotes and orders. My first tab "Quote Sheet" is data entered manually each time a quote is generated. We'd like to be able to mark Column A called "Order?" with an X to signify that the quote turned into an order and have the information copy over to the next tab "Order Log" on the next available row. (hoping this will save time and reduce error as right now it has to be entered manually on both)

Can someone help me figure out how to do this? I'm not sure if more information is needed....

Thanks in advance, any help is appreciated!

fdibbins · Answer

1 way would be to use filters to just show the rows with X in them.

Home tab/Editing (at the end)/Sort and Filter/Filter.
You will then see a bunch of drop-down arrows at the top of each column, click the 1 showing X's and uncheck BLANK

This will show on that same sheet, only those rows with X's.  To get all the data back, repeat the process and check ALL

Another way (hopefully the copy comes out OK...
Your data
H1	H2	H3x	aa	10	bb	20	cc	30c	dd	40	aa	50x	bb	60	cc	70	dd	80	aa	90x	bb	100x	cc	110	dd	120
Your extract...
H1	H2	H3x	aa	10x	bb	60x	bb	100x	cc	110		
E2=IFERROR(INDEX(A:A,SMALL(IF($A$2:$A$13="x",ROW($A$2:$A$13)),ROWS($A$1:A1))),"")
ARRAY entered using CTRL SHIFT ENTER, not just enter
Then copy down and across

Auto-copy rows from one tab to another based on cell value

1 response

Similar discussions

Subscribe To Our Newsletter!