G Whitehead
New Member
- Joined
- Aug 29, 2023
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
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"
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 |