http://www.rondebruin.nl/copy5.htm

--
Regards,
Tom Ogilvy


"mindpeace" wrote:


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 dont 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