save for each sheet separately into multiple files as pdf based on month

[Hasson]

hello

I have files contain many sheets and each sheet contains data for 12 months .the data are a1:g and the column A contains date M/DD/YYYY . what I want macro to save all of the ranges for all the months for each sheet separately . each month should be in one file for each sheet as PDF , but when save for each month I would create the headers for each month which save as pdf . the headers in row1 , then when save for each month it should contain the headers .
the directory is D:\DATA , but when save in this directory should create folders and thier names based on sheets names and the files should save in sheet is relating of it
and if I run the macro repeatedly should pops up message " the files have already existed ,do you want replace them ? " if press ok then replace it , if press no then nothing happens .
note: I want implementing macro for specific sheets( data,resource,monthly)


thanks

 

[Peter_SSs]

Duplicate to: save each range contains month as pdf for specific sheet based on inputbox

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.