based on Cell/Column content ,cut one sheet's values and paste it in other sheet?

M

mindpeace

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

based on Cell/Column content ,cut one sheet's values and paste it in other sheet? 3
Search column for date format; cut and paste multiple cells to row above 1
VBA Macro to Create Sheets Based on Column of Values 1
Create if partial match then copy and paste data from one cell to another 1
Macro to Format Multiple Sheets based on "Master" Format 0
Copy/paste rows to new sheet based on cell value 1
Value from one sheet paste under same value on other sheet. 7
Macro to copy row based on value into new sheet of same name 9

Top