Hi ,
First of all this is not any wild cross posting.
I have a Master Excel File with 9 sheets in it .
I need a VBA code to make subsets of this file(A new Excel file for each Market) into the different market Units that are there e.g Africa , ANZ , Greater China , India , Japan , ME, SEA , LATAM
with the same sheets except for the Sheets named SLIDE format AND LT SLIDE .
I have attached my Master file and one subset of Africa which is how I would like the output to be and the File name as attached .
Can this be achieved with a VBA code . Because making 8 Different Subsets weekly take s a lot of time Manually .
Really appreciate any help with a code on this one .
First of all this is not any wild cross posting.
I have a Master Excel File with 9 sheets in it .
I need a VBA code to make subsets of this file(A new Excel file for each Market) into the different market Units that are there e.g Africa , ANZ , Greater China , India , Japan , ME, SEA , LATAM
with the same sheets except for the Sheets named SLIDE format AND LT SLIDE .
I have attached my Master file and one subset of Africa which is how I would like the output to be and the File name as attached .
Can this be achieved with a VBA code . Because making 8 Different Subsets weekly take s a lot of time Manually .
Really appreciate any help with a code on this one .