Dear Group members, In attached excel file, I have a little vba code.
It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in Sheet2 equals Column A in Sheet1. The only problem occurs when the Items of Column D in Sheet2 are not unique. You can see there three 15-May-09. So it gets only the last data, which is 100,000,000.00 (at B19 in Sheet2), and ignores B17 and B18). Is there any way of improving this code to get the sum of B17, B18 and B20 into D13 in Sheet1? Thank you in advance. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Model.xls
Description: MS-Excel spreadsheet