Macros- Copy and Pest

[Kinetic_analytics]

I want to create macros.

Step 1: Copy data from one report from Cognos extract.

Step 2: Pest and append data in a new sheet.

This process will run once a week.

How can I do that?

Do you recommend any other easy solution?

Appreciate your help.

Thanks

[Qiu · Accepted solution]

If I understand your intention correctly, we can output the current dataset then read back for next week.

[Kinetic_analytics]

Thank you.

[Qiu · Accepted solution]

@Kinetic_analytics 

Glad to help and would apprecaite you could mark the solution as accept if it helps.

[Kinetic_analytics]

Question:

How can I remove previous data? The new week data will replace the previous week's data.  

Thanks