All,
I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am proposing loop which loops through the range F24:F40 in wkbk B and for each cell in that range tries to find if the unique id is already in the database (col A i wkbk A) and if so just overwrite it, and if not add to the last blank row in the database.
Thanks in advance.
I am in need of some help. I have two workbooks - A acts as a database of all our quotes, whilst B is a local file with just the quote info for that particular job. I am trying to write some VBA to loop through all the quotes in B (unique id in col F) and update the main database. I am proposing loop which loops through the range F24:F40 in wkbk B and for each cell in that range tries to find if the unique id is already in the database (col A i wkbk A) and if so just overwrite it, and if not add to the last blank row in the database.
Thanks in advance.