A1 Credits, B1 Debits , C1 Total of A1-B1
then next line A2-B2 +C1
Thanks for any Help.....Bob

I'm a beginner of Excel 2000 and I would like to create a drop down list on
the airfares, where different locations can be chosen, and when a location is
chosen, the cost will appear in the colums on the right.
  Expenses         Unit Cost     1 Day     2Days

Does anyone have a way of converting state abbreviations to the full
state name? Example AZ to Arizona. I have two lists I need to sort by
state and compare. One list has the abbreviation and the other the full
name. Of course they don't sort the same.

I'm constantly creating pivot tables that show sales information by
date across the top from left to right.  I would love to insert a
subtotal at the end of each calender quarter to subtotal the last
three months.  As it stands right now I just drop in the "Month" field

I have a report with 30 different options and I'd like to set up a formula
where for each option there is corresponding text.. How can I make this
happen? The options I have set-up are in cells a-e15 through a-e21. For
example a15 reads: Excavation. When it is chosen to be put ...

I have a pricelist file with SKUs in column A and prices for different types
of accounts in columns B-E.  In another file, I have sales by SKU, with
price paid.  Now I want to add the type of account to the sales file.
So, I need to find the right row in the pricelist file by ...

Cell B4 has the formula ($B$2*B5)
B5 to B455 are going to be filled with data usually daily but sometimes more
than once a day.
How can I make the formula in B4 say multiply B2 by whichever cell is the

When I open a .csv file in excel, everything opens in one column. Of
course I can use 'Data->Text to Columns' to put everything in seperate
cells, but for my work I have to do this a million times and it is
getting really annoying. Excel should be able to open .csv files and

This has probably been mentioned before. I tried googling and other
searching, but can't find the right keywords to get what I am looking
for without getting a ton of other garbage.
Basically, while experimenting for a program to determine a file format,

I would like to create a simple phone list. It has 3 columns: Contact , Tel
1, Tel2.
I want to be able to sort them alphabetically but also have the phone
numbers beside the contact follow.  How can I accomplish this?  I am very new

I have a set of about 250spreadsheet files each contaning 4 individual
sheets.  I now need to add an additional sheet to each file which will
contain cell references to cells on other sheets of that file.
I intended to add the sheet and create the cell references in one of

Is it possible to create a drop down list in a cell that looks at a range of
values on a different sheet?
Mike

I have a number of archived files in various versions of Lotus 1-2-3 which I
occasionally need to reference.  It is my understanding that Excel 2007 no
longer supports these file formates.  So, how can I access these files?  Are
there converters or add-ins available?

I cant' figure out what the exact words that I'm looking for and if I
did I would most likely find the answer.
I've got a spreadsheet that has a series of numbers in say column A
and it has the numbers 1,2,3,4,5

Currently when I am viewing a spreadsheet in excel and I want to open a
different spreadsheet they open in the same window which I find awkward.  I
would prefer for the 2nd spreadsheet I open to start a new instance of excel
so I can flick between the two on the taskbar.  Is ...