Years ago, when I was working, I remember using a function that
would allow you to build a table of output using one, and hopefully
two, input variables.  This is probably best illustrated with an
example.

I have the following columns.
  Svgs     Fee       Total
1  $25.00   $15.00    $15.00
2  $25.00   $0.00     $25.00

I am using Office XP, Excel...I am trying to transfer multiple worksheets
into a new workbook.  When I copy and paste or insert it as an object, I lose
the formatting, and the columns which I had hidden reappear.  How can I
transfer/copy my worksheets into a new workbook without ...

New to excel so go easy please...
..i need one cell to contain two functions with a drop down menu so i
can choose which one by name.  the functions are pretty easy, just sum
functions, which add the dada in different ways.  thanks for your help.

i need to create a spread sheet to use for tick marks through out the day.  I
need the ticks added up and then totaled by catagory.  How do I add the
values with in a single cell?

I have a vlookup that goes out to another file.
Because the other file has several worksheets it is only searching on the
worksheet that was selected is there any way to get the vlookup to look at
all the worksheets within a workbook.

i have a column of data, both text and numbers and would like to be able to
search for specific words in each cell and separate them onto there own
page.
example. "159 x 496 green door" "159 x 596 blue door" "720 x 396 green door"

How can I hide rows 21 through 54 and Columns I through BP when the
entire row/column is either 0 or blank between I21 and BP54?
Thanks,
Lynn

I'm an Excel newbie. I want to make a simple "common factor" formula.
But I don't know what function to use or the formula.
Example
A1 = 369

I am putting 2 filters on 2 worksheets in the SAME WORKBOOK.
I would like to see if I can do something like this:
1. if I click the filter on worksheet1 and select a value, it can be passed
to the filter on worksheet2 and shown the corrensponding result on worksheet

Can anyone tell me how to stop a number from incrementing by 1 when you grab
the corner of the cell and drag it down to copy the number into several cells
in the column.  It seems sometimes it doesn't and sometimes it does (add 1)
to the number.  I would like to choose when it ...

I want to make a spreadsheet that summaries information from previous
tab/worksheets within a single excel file.
For instance can you do A1 from sheet 1 multiplied by A1 from sheet 2, with
the answer appearing in A1 of sheet three?

Trying to link a cell in one worksheet to a cell in another worksheet using
the equals sign.  Sometimes it works, other times I get a #VALUE!  Sometimes
it woks in one colum of a worksheet and not another.  When it doesn't work, I
will sometimes get a 0 value instead of the ...

Short version:  I am creating a Sales Order form.  My salesman has
several hundred customers in a spreadsheet.  I would like to create a
pull down cell on my Sales Order spreadsheet that will allow him to
access the name column from his spreadsheet, when he selects a specific

i would like to copy addresses from 1 workbook to another workbook
automatically using a macro while both are open, there are only 10 cells
involved and i am
already using a macro to call up a worksheet from the first  workbook via