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

[Closed]
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
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!

1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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	H3
x aa 10
bb 20
cc 30
c dd 40
aa 50
x bb 60
cc 70
dd 80
aa 90
x bb 100
x cc 110
dd 120

Your extract...
H1	H2	H3
x aa 10
x bb 60
x bb 100
x 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