software

Im making these large table that are usually created from other tables,

I am trying to have word pull data from excel which is using the Vlookup
command. To avoid the #na problem I expanded the formula to this:

For reasons not entirely obvious, Office will not allow the use of an
ampersand (amp;) in an Excel custom header in XP.

This happens on MS excel 2003. It was fine until the today when a file was
opened almost all of the text was missing from the file. All the rest of the

Best site to begining to study Excel VBA MAcros--

Some setting has changed in Excel so that whenever I select quot;Save Asquot; for the
worksheet, the window that is displayed is the full size window. The arrows

I have a colum of 5 numbers. They are from 0 to 198, but in any random order.
My problem is, I need to use the top three ie: A1,A2,A3, unless any of them

I have a database with over 1,000 rows and 13 columns. One of the column
headings has a listing of about 23 different services. They want to add a

Is there a function in Excel that lets you copy and entire range from one tab
to another?

I have a table of 20,000 rows of employee training data. All of the columns
contain text or dates. The columns are (1) employee name (2) course name (3)

=IF(A1=1,IF(OR(COUNTIF(A1:AS2,1)=2*(COUNTIF(A6:E7, 1) COUNTIF(A11:E12,1) COUNTIF(A16:E17,1) COUNTIF(A 21:E22,1) COUNTIF(A26:E27,1) COUNTIF(A31:E32,1) CO UNTIF(A36:E37,1) COUNTIF(A41:E42,1)=1),1,quot;quot;),quot;quot;))

I have over 50 sheets in my workbook; each sheet contains a recipe, with new
ones being

I know that Excel will calculate payments, but is there a way to create an
amortization schedule?

I have a table in which each column represents a range of dollars. An
x in the row means that the person is in that range. I want to see if

I just installed Office2003 in conjunction with WinXP Pro SP2.
When Excel file (xls) is opened, quot;Filequot; menu is missing.

How do I set an active x control button so that it automatically adds a sheet
to an excel document when i click on it?

How can I filter 2 spreadsheets to include only those entries that are

it would be nice to be able to paste pictures in to excel cells to that the
pictures could be sorted along with associated text in different cells

Hi-

I have multiple text files(delimited) that I need to transfer to sheets
in a single excel file