Hi Kalyan, Have a look at the attached. The solution I've come up with is rather cumbersome, but I couldn't think of how to shorten it.
Regards - Dave. Date: Sat, 18 Sep 2010 16:16:27 +0530 Subject: $$Excel-Macros$$ Stock Monitoring from Raw data From: kalx...@gmail.com To: excel-macros@googlegroups.com CC: dilipan...@gmail.com; noorain.ans...@gmail.com; kumar.bemlmum...@gmail.com; davebonall...@hotmail.com; brunobbr...@gmail.com; koul.ash...@gmail.com; talk2mar...@gmail.com Dear Experts, I am facing a problem to lookup data from another sheet. Please help me. Details is in attached file. Thanks in advance Kalyan -- ---------------------------------------------------------------------------------- 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 7000 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 -- ---------------------------------------------------------------------------------- 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 7000 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
Stk Monitoring(1).xlsx
Description: Binary data
