more VBA code help...please!
It kind of sounds like you could use that same code that checks before it
copies.
But this time, if you don't see a match, you issue the warning (instead of
warning if you do find a match).
Anthony wrote:
Hi again,
when the user exits my workbook I want some code to check and see if the
data on the worksheet (data entered in range A7:O100) has already been added
to the 'database' (a worksheet named database). If it hasn't then add aLL the
data then show a msg box stating
-data copied to database please save and close programe again-
If it has then close save and close the programme
any help apreciated
many thanks
--
Dave Peterson
|