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

Closed
Marissa Garrock - Aug 16, 2016 at 10:31 PM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 16, 2016 at 10:58 PM
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

fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 1
Aug 16, 2016 at 10:58 PM
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
0