Hi there.
Another silly question for the day.
<tbody>
</tbody>
Take for instance the above table, As an example i have entered into A3 and A4 the same dates, Obviously the same calendar dates will have the same tide times and moon phase.
I am looking for a code that will auto generate Low Tide, High Tide and Moon phase from the previous line, But i would like to be able to manually enter the information for when the calendar dates are a new day.
This is part of a large table that generates new lines on a new entry, so i will need some way of coding this so that when i manually enter the information on a new date the code does not disappear and will auto generate again if i duplicate days.
This seems a little silly, but i am trying to create a fishing log to log and track the fish we catch for the season.
Is this at all possible?
Cheers
Another silly question for the day.
A | B | C | D | |
1 | Date | Low Tide | High Tide | Moon |
2 | 1/2/18 | 06:30 | 13:00 | Full |
3 | 2/2/18 | 07:15 | 13:45 | 1 Day Past Full |
4 | 2/2/18 |
<tbody>
</tbody>
Take for instance the above table, As an example i have entered into A3 and A4 the same dates, Obviously the same calendar dates will have the same tide times and moon phase.
I am looking for a code that will auto generate Low Tide, High Tide and Moon phase from the previous line, But i would like to be able to manually enter the information for when the calendar dates are a new day.
This is part of a large table that generates new lines on a new entry, so i will need some way of coding this so that when i manually enter the information on a new date the code does not disappear and will auto generate again if i duplicate days.
This seems a little silly, but i am trying to create a fishing log to log and track the fish we catch for the season.
Is this at all possible?
Cheers