Save record depending on cell values and if record already exists

I want to save a range of data (X8:bz8) into an array on another sheet programmatically. When the code is run, I want it to do one of three things depending on the value of two cells. I can easily express it as a formula but I'm battling to get the code right. Assume the cell values are

1. Cell "A1" (will show TRUE or FALSE), and
2. Cell "V6" (will contain a string which is a unique identifier).

Condition 1: If A1 = False and V6 already exists in a range (say C2:C5000 on another sheet), overwrite the existing data in the array with the data in X8:BZ8

Condition 2: If A1 = False and V6 does not exist in the range C2:C5000, append the data to the end of the array

Condition 3: If A1 = TRUE, show a message box saying 'the data exists and the record is closed', and do not amend or append the data from X8:BZ8 anywhere. (This should probably be the first condition tested.)

The code I have so far is:

Please Login or Register  to view this content.

Any help is much appreciated.

Hello
I created a mock-up workbook and your code worked fine with a couple of amendments.

Please Login or Register  to view this content.

The line marked red for the last row used argument was for column B (2), I changed that to C (3). I also added the A1 TRUE/FALSE test with message box.

Does this work for you?

DBY

Thanks for your help - it all works well. Rep added. Your help is appreciated.