zoso
Well-known Member
- Joined
- Oct 23, 2003
- Messages
- 725
I'd be really grateful if someone can help me here, as my spreadsheet is my inspiration for my running!
I have a worksheet (Sheet 1) called Training Log and another worksheet (sheet 8) in the same book called 90R Data. I enter a new row of data in the first empty row in Training Log after I've been out running every day (I'm a very keen runner!!!).
What I would really appreciate are the following 2 things please:
1. The data in Columns A, C & E of Training Log needs to be copied automatically into the first empty rows in Columns A, B & C respectively in 90R Data as soon as I've entered the data in Training Log.
2. The data being copied from Column E into Column C needs to be converted slightly, as I need the format in Training Log to stay as m:ss but when appearing in 90R Data, the ':ss' part needs to be converted to a decimal.
You might be wondering why I've not simply used a formula in rows A,B & C in 90R Data to do this. The reason is that cells for future entries need to be empty because they're linked to a chart showing my last 90 days runs and zero values would upset this - unless you know of a way round it.
3. I have minor niggle with the format of Column E in Training Log. This is conditionally formatted so that if I run below a certain pace the cell changes colour. Only trouble is, all the rows that are empty are showing this formatting as if the pace is zero. Can you tell me how to show the empty cells as normal but still retaining the conditional formatting when they are filled?
I'd be really grateful if there's anything you can do to help!
Thanks!
I have a worksheet (Sheet 1) called Training Log and another worksheet (sheet 8) in the same book called 90R Data. I enter a new row of data in the first empty row in Training Log after I've been out running every day (I'm a very keen runner!!!).
What I would really appreciate are the following 2 things please:
1. The data in Columns A, C & E of Training Log needs to be copied automatically into the first empty rows in Columns A, B & C respectively in 90R Data as soon as I've entered the data in Training Log.
2. The data being copied from Column E into Column C needs to be converted slightly, as I need the format in Training Log to stay as m:ss but when appearing in 90R Data, the ':ss' part needs to be converted to a decimal.
You might be wondering why I've not simply used a formula in rows A,B & C in 90R Data to do this. The reason is that cells for future entries need to be empty because they're linked to a chart showing my last 90 days runs and zero values would upset this - unless you know of a way round it.
3. I have minor niggle with the format of Column E in Training Log. This is conditionally formatted so that if I run below a certain pace the cell changes colour. Only trouble is, all the rows that are empty are showing this formatting as if the pace is zero. Can you tell me how to show the empty cells as normal but still retaining the conditional formatting when they are filled?
I'd be really grateful if there's anything you can do to help!
Thanks!