You will have to add a check in the macro so that it ignores previous data...

What identifies the current data?


"ivy" wrote:

Hi I'm doing a report right now using the macro, Is it possible if I run
again the macro it can only pick up the latest data inside? My report is
every week if I run again the data from the previous one also captured.

Thanks.