Name Manager: How to copy data from one sheet to another while avoiding alert message

Hi all,

I'm trying to put together macro that would copy data from one workbook (past version of the model) to another workbook (current version).

The problem is that I've defined names for some ranges (through data manager) and these are identical for both versions (current and past). As a result, when coppying data, there are always several alert messages telling you about this issues - that the name of the variable is already used.

Could you please suggest the way how to avoid these messages?

Thank you a lot for any help!

Thanks a lot for the answer! Exactly what I needed, works great!