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 “Demat” in cell , it should cut that cell and
paste in worksheet named “Dematt” , same in Demat sheet status of
complete row goes to billed sheet.

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

Help will be well appreciated


+-------------------------------------------------------------------+
|Filename: NEW INVONTROY SHEET.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4809 |
+-------------------------------------------------------------------+

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