Recording a Macro

[scpournara]

I have tried to record a Macro for a repetitive task I do many times per month. I export data, run a pivot table to summarize the data so I can then import it into another file. Here is the video of the process I go through and can not figure out how to make it work. Can anyone help? Is there a better way?

https://drive.google.com/file/d/1g45txVTjtkoEudPAuoW4YAK2ow75H61l/view

 

[rpaulson]

Probably do-able. Can you upload a small sample file of you raw data maybe 500 rows?

 

[Michael M]

What does this mean...

can not figure out how to make it work.

Have you tried doing part of it to makes sure it works, then adding to it ?
The recorded code won't work ?
It doesn't give the correct result ?
You can't the macro to run ??

Most posters won't sit through a video for your benefit....you'll have to provide more info....even if we do it in stages !!