How can i create a table in excel and display the table in a word document.  
I need the table to update as the data in the excel doc changes

I need to create a macro for adding additional rows from one linked
spreadsheet to another.
I have two workbooks that have spreadsheets that are linked.
Workbook 1: which has spreadsheets with rows of material added daily.

I'm trying to grab the table of CD rates at this website --
http://home.ingdirect.com/products/products.asp?s=OrangeCD
I can select the table with the external web query, but when it drops the
data into Excel the APY and Effective Date are not populated.  Looking at the

I have two sets of data that I want to summarize in another worksheet in the
same book.
Here is the exact data:
Worksheet Name: APAC_JAPAN LEARNING PARTNERS

I have a workbook with multiple functions - vlookups, sums, etc.  The
workbook was working fine, now, the cells are not updating when the data
changes.
For example, a sum of three cells does not update when one of the values in

I am trying to create a dynamically  named range.  However, the range keeps
selecting too many cells.
This function: =COUNTIF(PivotMONTH!$I:$I,">0") returns 47, which is the
correct number of rows.

I struggle with trying to add multiple if statements with other formulas such
as ceiling, round and mrounds.  So i am asking for help with the following.
I am multiplying column A by Column B.  The totals range from 48 to 34876.  
There are 20,000 rows.  I would like the values ...

I am using excel 2003.
I am trying to multiply 2 sets of data together for a project. However, I
need to find all the corresponding values of one set for a single given value
in another set.

I have raw data that runs about 55,000 rows in excel (without going into why,
we'd like to keep our formulas in excel as opposed to Access) with maybe
20-30 columns.  We then have a summary sheet which uses many sumproducts to
lookup on the data and return results base on ...

Keyboard shortcuts to move between worksheets within a workbook

As above does anyone know if it is possible to view a cells formula when the
cell is locked and sheet protected? Idea is to still see where the number is
linked to but not be able to make any changes?
thanks

I'm trying to return a value based on revision of a duplicate number.
For example I have the following lists on two separate sheets.
Sheet 1 Database
Column A        Column B        column C

My co-worker is having issues with a file that was exported to Excel.  One
column has text format and contains numbers.  He needs to add the numbers but
the column is text formatted.  He cannot use FORMAT CELL and select number.  
It appears to work but doesn't .  The column is ...

I am setting up monthly spread sheets for tax purposes.  I have each month
set up separately and a total page.  I want to know if you can put a formula
in on the total page (which is a separate worksheet in my workbook) that will
add up a single row from each worksheet an d give ...

I am in the US. How can I convert dates from the US format to Euorpean but
still have the dates be dates and not text. The custom format dd/mm/yyyy
makes the dates display the correct way but they are still actually in the US
format.