Hi
I have multiple sheets(DATA,SOURCE,OUT.....) contain data start from column (A) : column (K) , the date is in column A (DD/MM/YYYY) . what I want split sheet into multiple files as PDF based on month . but should create folder based on sheet name (DATA-2021,SOURCE-2022,OUT-2023)
folders names for years depends on data inside for each sheet
when save every file as PDF the data should relate the month for each folder .
should save file name JAN MONTH_2022 , FEB MONTH_2022 and so on up to finish year 2022 inside the folders and start again from new year 2023. and should replace the files inside the folders when run the macro every time .
I hope this clear
thanks
I have multiple sheets(DATA,SOURCE,OUT.....) contain data start from column (A) : column (K) , the date is in column A (DD/MM/YYYY) . what I want split sheet into multiple files as PDF based on month . but should create folder based on sheet name (DATA-2021,SOURCE-2022,OUT-2023)
folders names for years depends on data inside for each sheet
when save every file as PDF the data should relate the month for each folder .
should save file name JAN MONTH_2022 , FEB MONTH_2022 and so on up to finish year 2022 inside the folders and start again from new year 2023. and should replace the files inside the folders when run the macro every time .
I hope this clear
thanks
Last edited: