Hi,

I have recorded a macro for preparing Pivot Table.

I would like this macro to work for different excel files.

I require that when I enter path and file name in cell B2 in a file where
macro is stored, the macro picks up file stored in this location and runs the
macro that I have recorded and prepared pivot table.

Can you help me with this request.

Cheers,
Mandeep