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

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

Dave,
sorry, but any chance of some code????
wouldn't know where to start - apart from
Sub marco_test
End sub
Thanks again

"Dave Peterson" wrote:

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

I would think your code would be almost identical to the other code...

But this...


If FoundAGroupMatch = True Then
MsgBox "This log has already been copied to the database", _
vbExclamation
'exit sub '????
'...

would change


If FoundAGroupMatch = True Then
'already there
else
msgbox "the data ain't there yet."
end if



Anthony wrote:

Dave,
sorry, but any chance of some code????
wouldn't know where to start - apart from
Sub marco_test
End sub
Thanks again

"Dave Peterson" wrote:

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


--

Dave Peterson