How can you use vba to help me do this? WorkbookA has 3 columns with these respective headings: Code - showing a list of 200 stockcodes Price - blank Volume - blank WorkbookB has a list of over two thousand stockcodes with no headings. Each line shows the Code, the Date, the Opening Price, the High, the Low and the Volume traded for that day. How can I transfer the corresponding information to fill the blanks in WorkbookA and to skip a line if a code in WorkbookB is missing when it is not traded on that day? Thank you for your help.
Tom -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
