Hi

1) So there will be instances that there are cheques raised, but not a vendor sheet. Does this mean that if a sheet doesn't exist, you ignore the item, or will there be a default sheet that will contain all the other items?

3) I was referring to the starting row. It doesn't matter about the order of the data, but the starting row has to be row 6 not row 9. Is this going to be a problem?

4) Much easier if they are open. As this is going to be a manually controlled update, is there a problem with having it open? Is this data workbook likely to keep changing? Do you want the ability to nominate the data workbook, and have it open as part of the process?

rylo