Jon,
Like you, I'm new to Calc, and more experienced users may have better
suggestions, but here is an idea I've used in another spreadsheet:
1. In the first sheet, insert a new column to the left of the first
column which I think is actually your State column rather than your City
column.
Don Daugherty writes again:
I see that my use of tabs has screwed=up the appearance so let me
re-format what I just sent;
Jon,
Like you, I'm new to Calc, and more experienced users may have better
suggestions, but here is an idea I've used in another spreadsheet:
1. In the first sheet, insert
Hi
I am pretty new to calc but am trying to accomplish the following ...
In one sheet i have a rate table something like
city state hotel car
co denver 8823
ca menlo 90 45
nb denver 1000 12
for