thanks for ur reply Ledger.
well here i am trying to update one workbook in reference to other workbook... there many rows to be updated. so i want to create a macro which does the work automatically. in workbook named logbook i have models name and their corresponding quantity. i want that these same models's quantity in the different workbook("report.xls") gets 'added' (not copied) up. i want to automate this task . kindly help me with this.