HI ALL, I have two excel workbooks table1 and table2. Table1 has two sections :
ALL name score1 score2 score3 demo name score1 score2 score3 Table2 has : tablenum type month name score1score3 tablenum is 1(which is constant always ) type is ALL or DEMO Question is: I receive table1 for each month and I have to update table2 based on data received in table1. The macro should be able to compare two worksheets and extract score1 and score3 information for names in table1 by type variable and update table2. I need your help in writing a macro for the above condition. Thanks in advance, Skanda.! table num type month name score1 score3 name score1 score2 score3 name score1 score2 score3 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
table1.xls
Description: MS-Excel spreadsheet
table2.xls
Description: MS-Excel spreadsheet
