Hi Bob,

The message you are seeing is a warning message that Excel displays when you are copying data from one cell to another and the destination cell already contains data. The message is asking if you want to replace the existing data with the new data.

The reason you are seeing this message is because your macro is copying data to a cell that already contains data. If you want to turn off this warning message, you can add the following line of code to your macro before the copy command:

This will turn off all warning messages in Excel, including the one you are seeing. However, be careful when using this command, as it can suppress other important warning messages as well.

If you want to avoid overwriting existing data, you can modify your macro to check if the destination cell is empty before copying data to it. You can do this by using an IF statement in your macro.

Here are the steps to modify your macro:

1. Find the line in your macro that copies data to the destination cell.
2. Add an IF statement before the copy command to check if the destination cell is empty. The IF statement should look like this:
   
   
   Code:

   If Range("destination_cell").Value = "" Then

   Replace "destination_cell" with the cell reference of the destination cell.
3. Add an END IF statement after the copy command to close the IF statement. The END IF statement should look like this:
   
   
   Code:

   End If

After your macro has finished running, you should turn the warning messages back on by adding the following line of code: