Hi all, I'm new to VBA and have been given a rather difficult task. I understand this will probably take quite a bit of work, but if anybody could point me in the right direction it would be much appreciated.
I have one workbook which contains a set of particular values ID Start End Rank L 67105567 67115567 1.807 L 201319966 201329966 0.631 L 8383321 8393321 0.802 In another workbook I have the similar types of values ID Start End L 9612638 9972334 L 15351669 15419557 L 27433757 27507677 I am trying to figure out how to code a script in VBA that will scan the second workbook and determine if the values in this workbook are within the range of those found in the first and if a range within the second workbook falls within a range in the first then copy the value for the cell in Rank and paste it in the second workbook. Ex. Workbook 1 ID Start End Rank V 1 99 5 V 7 23 6 Workbook 2 (Original) ID Start End V 8 21 V 2 87 Workbook 2 (New) ID Start End Rank V 8 21 6 V 2 87 5 Again I know this is probably pretty tricky but if anybody could give me some pointers I would be grateful. Let me know if you need anymore information. Thanks. J.J. Rambo -- ---------------------------------------------------------------------------------- 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
