- Joined
- Mar 2, 2014
- Messages
- 3
- Reaction score
- 0
Hello,
I am working on a farmers market spreadsheet. I will be starting my seeds in my basement in large trays, Then they will be transferred them all to pots (that will be taken outside to harden), and finally, will be planting them in my large garden.
Each row will represent a week. I want to be able to enter a value in a cell above (for this example, let us assume that all of the values are all 4), that will cause 4 cells in the first column to show "Seed"(B20:B23). The next value, "Potted", will fill the next 4 cells in that column with "Potted"(B24:B27). The same will apply for "Planted"(B28:B31). I then want the same thing to happen in column C, but starting at C21.
Each new column (there will be 12 of them) need to offset by one more row. I believe that I can do those by simply starting the formula one cell lower in the next cells.
Not all plants grow at the same rate, so I will need to be able to change the variable that sets the number of cells filled for each type.
Thanks,
Dave
I am working on a farmers market spreadsheet. I will be starting my seeds in my basement in large trays, Then they will be transferred them all to pots (that will be taken outside to harden), and finally, will be planting them in my large garden.
Each row will represent a week. I want to be able to enter a value in a cell above (for this example, let us assume that all of the values are all 4), that will cause 4 cells in the first column to show "Seed"(B20:B23). The next value, "Potted", will fill the next 4 cells in that column with "Potted"(B24:B27). The same will apply for "Planted"(B28:B31). I then want the same thing to happen in column C, but starting at C21.
Each new column (there will be 12 of them) need to offset by one more row. I believe that I can do those by simply starting the formula one cell lower in the next cells.
Not all plants grow at the same rate, so I will need to be able to change the variable that sets the number of cells filled for each type.
Thanks,
Dave