ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   macro repeating getting the data (https://www.excelbanter.com/excel-discussion-misc-queries/210845-macro-repeating-getting-data.html)

Ivy

macro repeating getting the data
 
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.

Sheeloo[_3_]

macro repeating getting the data
 
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.



All times are GMT +1. The time now is 07:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com