mehdoush
03-16-2009, 07:10 AM
hey all
i'm using two workbooks "database.xls" and "ref to delete.xls"
"ref to delete.xls" contains reference numbers to delete in "database.xls",
when macro finds a that a ref number from "ref to delete.xls" in "database.xls", the entire row in "database.xls" that contains a ref. number in "ref to delete.xls" should be deleted.
notice: ref. no column is "A", in both workbooks
thanks in advance
regards
i'm using two workbooks "database.xls" and "ref to delete.xls"
"ref to delete.xls" contains reference numbers to delete in "database.xls",
when macro finds a that a ref number from "ref to delete.xls" in "database.xls", the entire row in "database.xls" that contains a ref. number in "ref to delete.xls" should be deleted.
notice: ref. no column is "A", in both workbooks
thanks in advance
regards