How to create a VBA macro that takes an excel master file & saves it as several new excel files

[pfaulkner]

Hi guys,

wondering if anyone can help me please,

I have a master excel data file and I would like to sort it and do some vlookups with a VBA and then save the data into separate excel workbooks that contains a pivot table and saves into a specific folder location.

I have no VBA experience at all but this would really help me in my job as it takes a whole day to complete this task.

thank you so much.