I have a micro that manipulate a range of data from $A1 to $P180 and it is working fine. The macro process the data and generate different PivotTables.

The data in this rang ($A1 to $P180) is vary based on the person who will download it. For example, when an employee from medical department download this data, he will got data related to medical while an employee from purchasing Dept will download his Dept related data only.

How can I send this macro to our users where they can use it over any data they will download from our main SAP system.

All Departments data that all our users can download from the server are located in the same range ($A1 to $P180) but the problem is that the SAP system downloads it in XLs file under different sheet name. it is something like (SAP23987download).

Your assistance is highly appreciated. Thank you.