Im in the process of trying to make an excel worksheet for a video game called "Vintage Story" In the game, there are some complex farming dates and it gets way too confusing to keep track of.
So I turned to using excel that I use for alot of games to help.
To the point:
I need excel to search a column for a specific word such as "Planting Turnip" Then check another cell that says how long that turnip plants for and go -Down- from that cell that many times and then type "Harvest Turnip"
For this refrence: Turnips take 12 days to plant and harvest.
In the game there are 12 days to one month.
I need it to look like this:
Can someone help me figuring out how to start with something like this?
So I turned to using excel that I use for alot of games to help.
To the point:
I need excel to search a column for a specific word such as "Planting Turnip" Then check another cell that says how long that turnip plants for and go -Down- from that cell that many times and then type "Harvest Turnip"
For this refrence: Turnips take 12 days to plant and harvest.
Turnip | N | 12 |
I need it to look like this:
March | 1 | Planting Turnip | Turnip | N | 12 |
March | 2 | Cabbage | N | 18 | |
March | 3 | Spelt | N | 24 | |
March | 4 | Rye | N | 24 | |
March | 5 | Amaranth | N | 24 | |
March | 6 | Pinapple | N | 72 | |
March | 7 | Sunflower | N | 22 | |
March | 8 | Bell Pepper | N | 26 | |
March | 9 | ||||
March | 10 | ||||
March | 11 | ||||
March | 12 | Harvest Turnip | |||
April | 1 |