Running Log editing -- can't find the macros

[DuncanFeldane]

David Hays posts an excellent running log with automatic charts on hi
website:
http://www.davidhays.net/running/runlog/runlog.html
I've been modifying it and wanted to add some charts.

For example, to the Totals Per Week sheet, I wanted to add Total Tim
Per Week.
I saw that the TPW table just pulls data from column B, which is whit
font on white background.
I copied the TPW table to another table and point it to column C (whic
contains a copy of column B so far), but can't seem to find the macr
that calculates "full_dist".

I was thinking I'd need to calculate "full_time" in a similar manner
but I'm stuck.

Can you help?
Dunca

 

[Bernie Deitrick]

Duncan,

This is the only macro:

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("data").Range("IParray").Sort _
Key1:=Worksheets("data").Range("b15"), _
Order1:=xlAscending, _
Key2:=Worksheets("data").Range("d15"), _
Order2:=xlAscending
End Sub

It's in Sheet1's codemodule.

Other than that, everything else is done by formulas (many that are array
formulas) and named ranges. So Full_dist is actually a named range, and the
totalling is done by the array formula.

Working with spreadsheets that are that developed can be a bit hard, as the
logic can be convoluted and hard to follow, especially with named ranges.

Good luck...

HTH,
Bernie
MS Excel MVP

 

[DuncanFeldane]

Bernie,
Thanks -- very helpful!

Never used a named range before.
Armed with that term, the help file suggested something helpful: inser

name > Paste > Paste List.

I'll let you know how it goes....

Dunca