Forum Discussion
column on left & #### signs auto populating
Two questions. Sorry I don't know the terminology so I will try to make my baby talk understandable as possible. This is a mileage log I found on the net a few years ago. It is set up to be numbe...
kr6el Well, somebody butchered the original template that had a structured table capturing all the data. The file you uploaded had all of the intelligence removed. I reinstated a structured table, with structured references and removed all the merged cells in the header rows. See if it works for you.
Wow that's awesome! Thanks.
So will I be able to enter several months of logs now?
So will I be able to enter several months of logs now?
kr6el Just type a date below the last row in the table and the table (including formulae) will extend. If not, let me know.
- the table is extending. Thanks.
The odometer is totaling backwards. For example - starting 100 miles, finish 200 miles = -100 mileskr6el Sorry! I swapped the columns. Should be Finish minus Start. Sorry! Compare and than you'll see what was wrong. Learn about structured tables and how you reference them. Very powerful!!