Just wanted to thank Ken Burnside, Harold Fuchs, and Brian Barker for
their quick responses. I had originally tried Ken's solution, nesting 3
IF statements, which worked very well. However I settled with Brian's
solution, for a couple of reasons. 1. I'm a lazy/bad typist, 2. The fact
that "State" was common to all 3 situations that resulted in H16 to =
135, resulted in a nice simple solution that will also work if a 4th or
5th variant of State comes along.
The second problem solution offered by Brian Seems good. However I would
like to write a macro that would automate it somewhat. I had already
created 3 named ranges from the Master list. I've been reading the book
by Dr. Mark Bain "OpenOffice.org Spreadsheet Macro Programming", and I
got lost in the oDoc, oSheet, and the oRange funtions in UNO. For now
I'll just stick with the copy and special paste method.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
