Creating a macro to apply to another workbook

Hi all,

I'm pretty new to VBA so please be patient

So, I have a workbook that is full of data, downloaded from SAP. I would like to create a macro that will work from a different workbook to apply filters and add formulae to the columns to trim the downloaded file down into one that is presentable. The reason I want this to be the case is that the user will download the data from SAP, but I don't want them to have to go through the rigmarole of having to apply all of these formulae themselves.

Also, since the user could save the workbook under any name, is there a way for the macro to recognise what workbook to apply the filters to? Or perhaps a user input?

Thanks in advance for your help.

Bump. Any help please?

Bump again. Does anyone have any feedback?

Any suggestions would be greatly appreciated.

Any help out there? This still hasn't been solved :$