I would use =VlookUp in the corresponding cells in WorkbookA. You can find some good videos on Youtube.com if you are unfamiliar with lookup tables
On Jan 10, 1:13 am, Tom <tcli...@gmail.com> wrote: > 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
