need help

[saud]

I have an excel sheet which contain 13 sheets, each sheet contain 12 tables ( one table for each month )
I made the 13 sheets as a list but i faced problem with transfer data to the required month
I need code to solve this problem ( transfer data to the chosen page witch match the chosen month )

 

[fadee2]

hi saud,
Welcome to the board.

I would suggest providing a sample file that would make it easier for everyone trying to help, to better understand and suggest solutions accordingly, rather then interpreting the query and making assumptions.

hth...

 

[My Aswer Is This]

I looked at this post but have several questions:
Like you said:
I have an excel sheet which contain 13 sheets, each sheet contain 12 tables ( one table for each month )

One sheet cannot contain 13 sheets.
Or do you mean you have 1 Workbook that has 13 sheets.

And I need more specific details.

I would suspect you have 1 sheet with 12 Tables and now you want these Tables copied to 12 different sheets. So, Table named "January" would be copied to sheet named "January" and on and on

And are these 12 sheets named "January" and so on already made or do we need to create the sheets.
See I need specific details like this.

Like what is the name of the sheet with the 12 Tables.
And how exactly are the Tables named.

Is it "January" or "Jan"?

I would prefer you provide specific details and not upload your file.
I never open uploaded files.

 

[saud]

‏‏حسابات نهائي - تطوير.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2				الرمز	MARAFIQ
3
4
5		الشهر	يناير				السنة	2022
6
7		التاريخ	01/01/22				رقم الشحنة	1
8
9			API	33		0.05
10
11		الكمية ( bbls )	250000		LT			MT
12
13
14
15
Main

Cells with Data Validation
Cell	Allow	Criteria
E2:F2	List	=$Q$20:$Q$32
C5	List	=$P$21:$P$32
F9:G9	List	=$O$20:$O$34
H5	List	=$N$23:$N$26

‏‏حسابات نهائي - تطوير.xlsm
	A	B	C	D	E	F	G
1				2022	يناير
2		AL	نوع الخام	YLS	الرمز		الجهة
3		صافي الأطنان	صافي البراميل	الرواسب	الكثافة	رقم البطاقة	تاريخ البطاقة
4		6.09	50	0.05	50	12	20/1/2020
5						12
6						12
7						12
8						12
9						12
10						12
11						12
12						12
13						12
14						12
15						12
16						12
17						12
18						12
19						12
20						2
21						12
22						12
23						12
24						12
25						12
26						12
27						12
28						12
29						12
30						12
31						12
32						12
33						12
34						12
35		6.09	50			31	المجموع
36
37
38
39				2022	فبراير
40		AL	نوع الخام	YLS	الرمز		الجهة
41		صافي الأطنان	صافي البراميل	الرواسب	الكثافة	رقم البطاقة	تاريخ البطاقة
42		24.47	200	0.05	49	20	20/1/2020
43						12
44						12
45						12
46						12
47						12
48						12
49						12
50						12
51						12
52						12
53						12
54						12
55						12
56						12
57						12
58						12
59						12
60						12
61						12
62						48
63						12
64						12
65						12
66						12
67						12
68						12
69						12
70						12
71						12
72						48
73		24.47	200			31	المجموع
74
75
76
77				2022	مارس
78		AL	نوع الخام	YLS	الرمز		الجهة
79		صافي الأطنان	صافي البراميل	الرواسب	الكثافة	رقم البطاقة	تاريخ البطاقة
80		6.09	50	0.05	50	12	20/1/2020
81						12
82						12
83						12
84						12
85						12
86						12
87						12
88						12
89						12
90						12
91						12
92						12
93						12
94						12
95						12
96						12
97						12
98						12
99						12
100						12
101						12
102						12
103						12
104						12
105						12
106						12
107						12
108						12
109						12
110						12
111		6.09	50			31	المجموع
112
113
YLS

Cell Formulas
Range	Formula
B4:B34,B80:B110,B42:B72	B4	=O4
B35:C35,B111:C111,B73:C73	B35	=IF(SUM(B3:B34)=0,"--",SUM(B3:B34))
F35,F111,F73	F35	=IF(COUNT(F4:F34)=0,"--",COUNT(F4:F34))

these tables are 12 one for each month
sheets name are listed

 

[fadee2]

by looking at your data samples, looks like you are gathering data and you want it to be distributed on separate worksheets, sorted by month names for a year. is this what u need?

If yes then, why don't you keep all of your data in a single worksheet and use it for reporting? This way, all your data will remain in a single worksheet, and can be reviewed on separate reporting worksheet. this would reduce the hassle of creating multiple worksheets (monthly).

hth...