Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I hope you can help me with this please?
When either the word 'REST' or 'OTHER' (both words upper case only) are the first words entered in Column B of the last row of Sheet 'Training Log' I need a 0 (zero) inserting into the first blank cell of Sheet 'Daily Tracking'.
Sheet 'Daily Tracking' Cols D1:CC1 contain years from 1984-2061. Rows 2:367 contain days of the year (including Feb 29).
I need the zero entering in the first cell in the column (searching from the top of the sheet downwards) in the current year (whichever year that is) that does not contain a value, including a zero value i.e. blank and takes account of leap years.
The code to locate the relevant cell in Daily Tracking has already been very kindly provided here - Post #5
All I need is for the above code to be integrated with the 2 conditional words to produce the zero in Sheet 'Daily Tracking'.
Help would be very much appreciated, thank you!
I hope you can help me with this please?
When either the word 'REST' or 'OTHER' (both words upper case only) are the first words entered in Column B of the last row of Sheet 'Training Log' I need a 0 (zero) inserting into the first blank cell of Sheet 'Daily Tracking'.
Sheet 'Daily Tracking' Cols D1:CC1 contain years from 1984-2061. Rows 2:367 contain days of the year (including Feb 29).
I need the zero entering in the first cell in the column (searching from the top of the sheet downwards) in the current year (whichever year that is) that does not contain a value, including a zero value i.e. blank and takes account of leap years.
The code to locate the relevant cell in Daily Tracking has already been very kindly provided here - Post #5
All I need is for the above code to be integrated with the 2 conditional words to produce the zero in Sheet 'Daily Tracking'.
Help would be very much appreciated, thank you!