Autopopulate? is it possible

[lherndo]

Tough to explain, but here goes.
On Worksheet 1 I have columns with date, customer name, make, model..
and a column with a dropdown menu of different steps in the sale
process. (looking, test drive, sold, dead...)

I would like for any row that has column J selected as "Sold" t
automatically copy columns B, D, I & L to Worksheet 2 corresponding t
B ---> A, D-->B, I-->D, and L -->F

So Worksheet 1 B = date, D= customer, I=salesman, L=manager
But on Worksheet 2 A=date, B=customer, C=salesman and D=manager

Worksheet 1 is my customer and deal input sheet, and on worksheet 2
I'll only track the sold deals, and I will be inputing gross profit an
so on.

I know I can copy and paste, but as powerful as Excel is, i was hopin
I could get it to move over after I use the dropdown menu and selec
Sold.

PS - When i select Sold in the dropdown box, it automatically turn
green. So if it's easier to automatically pull over to Worksheet
being green instead of saying Sold that's fine

 

[Debra Dalgleish]

Instead of moving the Sold items to a different sheet, you could use the
AutoFilter feature to display only those rows. There are instructions in
Excel's Help, and here:

http://www.contextures.com/xlautofilter01.html