Hi All
I have data in my excel sheet as follows'
*Status * *a* *b* *c* *d*
*e* *g* *h* *i**
*Work in Progress
sfdf shdflsdf lflsdfj dfhdsfh ljhslhsdfl a
aa aa
Closed fdfg
ksgdfkgf kgafkg klghfks kgfkgsfdk kghsfdkgsdf khgdfksdf
kjdshfkgfsdfhsdf
Assigned
sjfgsdfg ksgfsdg gsdfdgf klgfkgs gfkgf fgdfsg kgsdfksgdf
kgafgsdf kgsdfgf
in the above case i am only changing status column all the time usually i
change status to *Work in Progress, Closed, Assigned, *
**based on the status in the status column, my data has to move. If the
status is *Work in Progress* data has to move Sheet2 (Entire Row), if its *
Closed* data has to move to *Sheet3* and if is *Assigned* data has to move
to *Sheet4*
Please let me how i can do either by using formula or through writing Simple
Macro
--
Thank You
Patil MG
9663374848
Life is Very Beautiful!!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸•´ Smiling!
`•.¸.•´.
--
Thank You
Patil MG
9663374848
Life is Very Beautiful!!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸•´ Smiling!
`•.¸.•´.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
