View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mindpeace mindpeace is offline
external usenet poster
 
Posts: 1
Default based on Cell/Column content ,cut one sheet's values and paste it in other sheet?


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