Garden Calendar

[G Whitehead]

I am making a planting calendar,
I would like when "P" (Planting) is inserted into a column, Excel will then depend on variety input "E" (expected harvesting) so many columns (days) after planting.

Once the plant has been Harvested (H) would be inputted manually.

Then that row would go to the bottom of the page.
Essentially I would like all plants that are expected to be harvested at the top until the plants have been harvested.

I have manually inputted examples to show what I would it should look like with the "P" "E" "H"

Successional planting - PLAN.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY
1						July
2	Complete	Variety	Shed	Row	Level	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
3		GC	4	16	B	P																				E			H
4		BH	8	3	T	P			E	H
5		GO	3	3	B	P										E		H
6		GC	2	2	B	P																				E
7		CO	2	2	T	P									E
8
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F3:BA1440	Cell Value	contains "G"	text	NO
F3:BA1440	Cell Value	contains "P"	text	NO
F3:BA1440	Cell Value	contains "H"	text	NO
F3:BA1440	Cell Value	contains "E"	text	NO
F3:BA1440	Cell Value	contains "D"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B3:B36	List	=Sheet2!$D$2:$D$8
C3:C92	List	=Sheet2!$A$2:$A$9
D3:D92	List	=Sheet2!$B$2:$B$52
E3:E92	List	=Sheet2!$C$2:$C$3
F3:BA1440	List	P, H, E

Successional planting - PLAN.xlsx
	A	B	C	D	E	F
1	Sheds	Rows	Height	Variety	Growing Days
2	2	1	T	GC	20
3	3	2	B	RC	20
4	4	3		CC	20
5	5	4		GO	10
6	6	5		RO	10
7	7	6		CO	10
8	8	7		BH	3
9	9	8
10		9
11		10
12		11
13		12
14		13
15		14
16		15
17		16
18		17
19		18
20		19
Sheet2

 

[SanjayGMusafir]

Once the plant has been Harvested (H) would be inputted manually.

Then that row would go to the bottom of the page.

Check this -

Just add a helper column at the end or at beginning, to you convenience. And then sort the data in ascending order of the helper column.

To automate it you will need VBA.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1						July
2	Complete	Variety	Shed	Row	Level	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Check
3		GC	2	2	B	P																				E											0
4		CO	2	2	T	P									E																						0
5		GC	4	16	B	P																				E			H								1
6		BH	8	3	T	P			E	H																											1
7		GO	3	3	B	P										E		H																			1
Sheet1

Cell Formulas
Range	Formula
AK3:AK7	AK3	=COUNTIFS(F3:AJ3,"H")