hi
I have file contains sheet and the sheet contains data throughout of the year. the date is existed in column c and the data starts from C2: P of course the headers begins from row1 what I want create folder name's OPERATION and the folder OPERATION should contains the saved files as pdf . so should save the files for each month alone . I mean if the sheets data contains in column C 1/12/2021 ,2 /22/2021 when save the file alone should be based on month ( the files rename based on month for each file like this OPERATION_JANUARY , OPERATION_FEBRUARY and If I repeat to run the macro should gives message " do you want replace or create another copy " if I press ok then should replace and if I press no should pops up another message " do you want create new copy if I press ok , then should create new copy and if I press no , then should not create & shouldn't replace .
as to when create new copy then should increment number like this OPERATION_JANUARY(1) , OPERATION_FEBRUARY(1)
note: when save for each file should contains the headers as in orginal sheet in row1 for each file alone as pdf
thanks
I have file contains sheet and the sheet contains data throughout of the year. the date is existed in column c and the data starts from C2: P of course the headers begins from row1 what I want create folder name's OPERATION and the folder OPERATION should contains the saved files as pdf . so should save the files for each month alone . I mean if the sheets data contains in column C 1/12/2021 ,2 /22/2021 when save the file alone should be based on month ( the files rename based on month for each file like this OPERATION_JANUARY , OPERATION_FEBRUARY and If I repeat to run the macro should gives message " do you want replace or create another copy " if I press ok then should replace and if I press no should pops up another message " do you want create new copy if I press ok , then should create new copy and if I press no , then should not create & shouldn't replace .
as to when create new copy then should increment number like this OPERATION_JANUARY(1) , OPERATION_FEBRUARY(1)
note: when save for each file should contains the headers as in orginal sheet in row1 for each file alone as pdf
thanks