I am on Excel 2003,. I have a spreadsheet with 12 monthly tabs one for every month of the year January, February … December.. This file is called montly_totals.xls and is located in P:\DAM\WI_FTP. There are a total of 200 accounts set up in each of these monthly tabs. Each of these accounts starts with a code in A1 & B1 . These are 4 character codes like below: They are sorted by Code 1. Code 1 + Code 2 uniquely identify a record.
Code1 Code2 0845 MTRA 1016 BBBB 1017 LEGL 1605 1605 1605 OSLA 7777 0001 7777 0002 Every month I download a comma delimited file named as WI_JAN_2011, WI_FEB_2011 and so on till WI_DEC_2011. This file is located in P: \DAM \WI_FTP This file may contain 10 to 150 accounts with updated information for that specific month. They also have the same codes as above. The format of the comma delimited file is : Code1,Code2,YR,MM,CoName,Dept_name,Quantity,$amount 0010,BBBB,11,01,Iron works ,Grills , 000000130,0000003448635, (they are all on one line) Currently every month I have to open each monthly tab and manually copy and paste the correct Information from the comma delimited file into the exact columns in my montly_totals.xls spreadsheet. The columns I copy are : YR,MM,CoName,Dept_name,Quantity,$amount I want a macro that would read this comma delimited file and insert these new monthly updated values to the correct account numbers. I was thinking that it could key on Code1 & Code2 fields. Once there is a match between the codes i.e Code1+Code 2 in the montly_totals spreadsheet and the comma delimited file than the macro could insert the complete record (YR,MM,CoName,Dept_name,Quantity,$amount ) for that match in the columns C, D,E,F,G, & going dow the rows. If there is no match than a new record should be inserted maintaing the sort order. Thanks in advance, Dave -- ---------------------------------------------------------------------------------- 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
