I have a huge (30MB) pivot table with lots of market data.  However, I need
to pull this into Access in order to really crunch the data properly.
The data looks like this:
Region Vendor Product shipped units, etc.

I have a series of pivottables on different tabs.
I have the first one updated from an MS access database. The rest of
the pivottables are all built on the data from the first pivot table.
I have a macro set up to do the requery to the database which works

When using autofilter is it possible to sum or average columns of numbers?  
When I filter a data base the column return includes all the filtered out
numbers.  If not is there an add on I can use?  Thank you for any help you
can provide.

How do you Copy a formula from one workbook to another.  I make updates to a
daily changing workbook, so when I have the updates ready i need to transfer
them form one workbook to the original.  When I do, the formulas reference
the workbook that I update, not the original.  How ...

I'm trying to create a fn that will give me the contents of the last cell in
specific rows.  The column of that cell differs by row, unfortunately, and
occasionally the content is '0', which I would need to have as a result of
the formula.  Any assistance would be greatly ...

I have a ppt in Italian that i need to translate in English. Office help
tells me to choose "Translate entire document" under Translation option in
the Research pane but i am not able to find this option at all. The only
option i seem to have under tanslation is "Translate words ...

I have a workbook with several tabs.  The top tab is the main spreadsheet
were I enter all my gathered data.  The other tabs are the same spreadsheet,
the same data, but broken out by specific building.
Right now, I enter the data (alpha and numeric) into the main spreadsheet,

How do I split a single cell of data into multiple cells, when it is a
continous text string without delimiter characters?  I want each single
charcter of the string in its own cell.
I am importing an ascii file and can separate the data manually during

I am trying to create muliple formulas for one column.
Column C - I have client Age
Column G - This is going to be any value, however if the client is younger
than 50 years of age, the max value is $15,000.  If the client is above the

We are currently using a manual shipping form each time we want to ship
something and the shipping department manually processes it and returns a
carbon copy of the form.
We'd like to automate that in Excel (not sure if Outlook would be better)

I am trying to convert some times in my spreadsheet. I know how to convert
mins. to hrs but the problem I am having is this for example:
I need 39.20 to show as 39.33.
Does any one know the formula or how I can do this?????????

Help.  I am new to this.  I have a worksheet that somehow I hit create a list
( I think) and it hightlights that column with a blank cell and a blue
astrick.  When I try to sort my data now the sort button is not highlighted
and I can not sort.

I dont know why the NETWORKDAYS function gives me a NAME error.
Please help
gary

I am not sure if this can be done or not, but I am looking to find a formula
or something to sum values of a list, but only sum if there is more than one
product.
Here is the example:  I want to add 60971, 60975, 60982 dollar amounts to

How can I write an IF formula where I can type a NUMERIC value in one cell
and the adjacent cell automatically types TEXT selected from another Excel
Workbook?
Example: While in Workbook (Estimates.xls) in cell C22, I want to type an IF