Dear All,
This is the problem haunting me for long time , i am very expert in VBA
.. hope some will give me solution

Have workbook with call status , with 15 columns 11th column give the
status of the sales call .

I want to create automated macro which will copy row data based on
status cell content to other sheet with same name as in status cell.
Suppose you have status “pending” in cell , it should cut that cell
and paste in worksheet named “pending” , same in pending sheet status
of complete row goes to complete sheet.

I have seen this working but I don’t remember the exact website.

Help will be well appreciated


--
mindpeace
------------------------------------------------------------------------
mindpeace's Profile: http://www.excelforum.com/member.php...o&userid=28759
View this thread: http://www.excelforum.com/showthread...hreadid=544991