Have a look at the attached workbook.
Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de vickey Envoyé : mercredi 10 août 2011 18:53 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ VB Code Require for Data Compilation Hi, I am using a huge database of family and members, with column address / DOB / Emp Code. Now what I want, since the address and EmpCode is only agaisnt primary member, so after executing command, I want that address should be filled in each member of family alongwith EmpCode, apart from this age of each members should be calculated with current date. Now next thing is that the calculation of family no. & sr. no. within family should also be calculated. here I am attaching samplevkey.xlsx file for ready reference where sheet1 is having raw data & sheet2 having result data. Since I am working with huge data in thousand, so its really tough to manage the things mannually. Please help me out. thanks in advance. -- ---------------------------------------------------------------------------- ------ 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 -- ---------------------------------------------------------------------------------- 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
samplevkey.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
