![]() |
|
#1
|
||||
|
||||
![]() Nazarine. You almost have it. change the ranges from $A$1:$B:$B1000 to just A$:B$
It actually makes the vlookup a bit faster. Other than that I agree. I think that is the best way unless he goes with VBA. Depending on what he is looking for.
__________________
150 G mixed reef. ![]() |
#2
|
|||||
|
|||||
![]() Nice!! I was always wondering if there was a better way than a specific table range. That tip will help with some of my dynamic sheets that have data pulled from a database.
__________________
28g Nano Cube drilled with 13g sump in stock stand. Vertex IN80 Skimmer, Phosban 150 Reactor, Apex Controller, DIY LED with stock hood, dimmable Established March 2006 |
#3
|
||||
|
||||
![]() I would go with a VBA app myself but I'm kind of a Excel Geek.......
__________________
150 G mixed reef. ![]() |
#4
|
|||||
|
|||||
![]() 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
__________________
Dan Pesonen Umm, a tank or 5 |
#5
|
|||||
|
|||||
![]() 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.
__________________
Mike 77g sumpless SW DIY 10 watt multi-chip LED build ![]() |
#6
|
|||||
|
|||||
![]() umm, I dunno
__________________
Dan Pesonen Umm, a tank or 5 |
#7
|
|||||
|
|||||
![]() 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.
__________________
Mike 77g sumpless SW DIY 10 watt multi-chip LED build ![]() Last edited by mike31154; 04-24-2009 at 03:48 PM. |