MS Excel wizz's Is there a script for?

[Glennrf38]

I would go with a VBA app myself but I'm kind of a Excel Geek.......

[banditpowdercoat]

OK, I'm lost here.
cav-fire has a copy of whta I have, Heres a link to what I am using

http://www.banditpowdercoat.com/Down...parameters.xls

[mike31154]

Is there a reason you've broken the date into two columns, i.e., month across the top and day down the left? Why not have the entire date in one cell, which can be formatted as a date type cell? That way you could use one column/row for the entire date value and then use the second column/row for all your parameters on one sheet, vice having a separate sheet for each parameter. Then you can work on a separate sheet to consolidate the info using the value lookup function recommended by the other dudes/dudettes.

[banditpowdercoat]

umm, I dunno

[mike31154]

Something like this....



The last date entry uses the function which automatically inserts today's date. All the previous ones are entered manually as the date the parameters were taken. There's also a feature in Excel (Freeze Panes under the Window menu) which allows you to lock the top row so that when you scroll down, it continues to be displayed for reference.

[banditpowdercoat]

Hey Mike, thx. Locking the top row would be neat. That page looks good. I don't know why I never thought of putting it that way.

[mike31154]

No probs and no need for complex look up formulae this way, but you can still do it if you wish to produce a graph or something on a separate page. To lock/freeze the top row, in my example pic, you would select the entire row 2 by clicking on the the number 2 on the left (second row), then click the Window menu and choose the "Freeze Panes" option.