Perhaps you should paste your code into a message...

Where does the duplication take place?

In article ,
Sheetal wrote:

I have created a macro that can takes data from another spreadsheet, and
copies values individually into various cells. I am not copying the
the whole spreadsheet, only various bits.

My problems is, every time I run the macro, it duplicates the original
data. should i run the macro from a different spreadsheet, or should i
run it from the same spreadsheet. how can i avoid this duplication?

thanks