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
If I understand your intention correctly, we can output the current dataset then read back for next week.
@Kinetic_analytics
Glad to help and would apprecaite you could mark the solution as accept if it helps.
Thank you.
Question:
How can I remove previous data? The new week data will replace the previous week's data.
