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

[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 show inputbox and write the sheet after this should save all of the ranges for all the months separately not in one file . each month should be in one file for written sheet into inputbox 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 .


thanks

 

[Hasson]

almost one weak ago nobody answers

 

[DanteAmor]

I have files contain many sheets and each sheet contains data for 12 months

Do you have several books?

If file1 has "monthly" sheet, what are the pdf files called for month 1, month 2...?
Now, if you have another file2, with a sheet with the same name "monthly", then what are the pdf files going to be called for month 1, month 2...?

The new folder will be named "D:\DATA\monthly\"?

 

[Hasson]

Do you have several books?

at least 12 files

If file1 has "monthly" sheet, what are the pdf files called for month 1, month 2...?

should be monthly

Now, if you have another file2, with a sheet with the same name "monthly", then what are the pdf files going to be called for month 1, month 2...?

yes , this is not problem because every file should create new folder as same file name inside directory
every new folder should create based on file name and save the sheets inside it . sorry if I don't make clear this point from the beginning .

 

[Hasson]

for correction

If file1 has "monthly" sheet, what are the pdf files called for month 1, month 2...?

yes you're right

 

[DanteAmor]

yes , this is not problem because every file should create new folder as same file name inside directory
every new folder should create based on file name and save the sheets inside it . sorry if I don't make clear this point from the beginning .

It's still unclear to me.
You can give examples of the names of your files, names of the sheets of each file.
Names of the destination folders, how the pdf files would look in each folder, and the name of each pdf.

Perform the example with at least 3 files.

 

[Hasson]

my apologies ! after see my OP you're right this is not clear and I don't mentioned so forget this

yes , this is not problem because every file should create new folder as same file name inside directory
every new folder should create based on file name and save the sheets inside it . sorry if I don't make clear this point from the beginning .

just create new folder based on sheet name and save each range based on month as pdf

 

[DanteAmor]

just create new folder based on sheet name and save each range based on month as pdf

It's not enough to understand what you want. You must give examples as I asked you in the previous post.

 

[Hasson]

ok I will do soon

 

[Hasson]

sorry for delaying , it takes more time to do that .
file name PUR1 ,PUR2,SEARCH . take PUR1 should create folder based on folder name PUR1 to become the directory D:\DATA\PUR1\
the data in file PUR1 contains many sheets for instance take sheet name DTR then should crate folder name DTR inside folder PUR1 to become directory D:\DATA\PUR1\DTR\
the data in file PUR1

PUR1.xlsx
	A	B	C	D	E
1	DATE	ID	BARCODE	WHARE HOUSE	QTY
2	11/5/2021	QQW-1 MM CLA1 23M-1 IT			200.000
3	11/6/2021	QQW-2 TH NM-1 CLA2 VBG L CHI			300.000
4	11/7/2021	QQW-3 CV CLA3 TA			400.000
5	11/8/2021	QQW-4 M*12.5 CLA4 TR			500.000
6	11/9/2021	QQW-5 CLA5 EG			600.000
7	11/10/2021	QQW-6 M230 TU			700.000
8	11/11/2021	QQW-7 S** CLA7 US			800.000
9	11/12/2021	QQW-8 CLA8 UK			900.000
10	11/13/2021	QQW-9 CLA9 N BR			1,000.000
11	11/14/2021	QQW-10 BN CLA10 IT			1,100.000
12	12/15/2021	QQW-11 LVD CH			1,200.000
13	12/16/2021	QQW-12 CLA12 JA			1,300.000
14	12/17/2021	QQW-13 CLA13 TR			1,400.000
15	12/18/2021	QQW-14 L/R CLA14 SS230 EG			1,500.000
16	12/19/2021	QQW-15 CLA15 TU			1,600.000
17	12/20/2021	QQW-16 CLA16 US			1,700.000
18	12/21/2021	QQW-17 CLA17 UK			1,800.000
19	12/22/2021	QQW-18 RRSDF BR			1,900.000
20	12/23/2021	QQW-19 CLA19 IT			2,000.000
21	12/24/2021	QQW-20 KV/1**2 CLA20 CHI			2,100.000
DTR

so when create the folders & save files

create folder DTR based on sheet name inside folder PUR1

save each range based on month as pdf file

to see inside files when open them
file MONTH_11

MONTH_12

file name SEARCH
data

SEARCH.xlsm
	A	B	C	D
1	ITEM	ID	DESCIBE	PRODUCTION BY
2	2/11/2022	QQW-1 MM	CLA1 23M-1	IT
3	2/12/2022	QQW-2 TH NM-1	CLA2 VBG L	CHI
4	2/13/2022	QQW-3 CV	CLA3	TAI
5	2/14/2022	QQW-4 M*12.5	CLA4	TR
6	2/15/2022	QQW-5	CLA5	EG
7	2/16/2022	QQW-6	M230	TU
8	2/17/2022	QQW-7 S**	CLA7	US
9	3/18/2022	QQW-8	CLA8	UK
10	3/19/2022	QQW-9	CLA9 N	BR
11	3/20/2022	QQW-10 BN	CLA10	IT
12	3/21/2022	QQW-11	LVD	CH
13	3/22/2022	QQW-12	CLA12	JA
14	3/23/2022	QQW-13	CLA13	TR
15	4/24/2022	QQW-14 L/R	CLA14 SS230	EG
16	4/25/2022	QQW-15	CLA15	TU
17	4/26/2022	QQW-16	CLA16	US
18	4/27/2022	QQW-17	CLA17	UK
19	4/28/2022	QQW-18	RRSDF	BR
20	4/29/2022	QQW-19	CLA19	IT
21	4/30/2022	QQW-20 KV/1**2	CLA20	CHI
RP

create folder based on folder name SEARCH to become the directory D:\DATA\SEARCH\
the data in file SEARCH contains many sheets for instance take sheet name RP then should crate folder name RP inside folder SEARCH to become directory D:\DATA\SEARCH\RP\

so when create the folders & save files as pic1 will see creat folder search

create folder RP based on sheet name inside folder SEARCH

save each range based on month as pdf file

to see inside files when open them
MONTH2

MONTH3

MONTH4

I hope this si help