Hello, In Excel 2007 we are trying to import an External Excel file into an existing workbook, however, when the data is brought over it simply shifts the...

Hi I want to use a formula or similar to update a cell when another cell has a higher value, and maintain this relationship, e.g. cell B1 will always contain...

Is it possible to mass modify the format for multiple comments (or all comments) in a workbook? Or do you have to modify every comment individually? Thnx.

Hello All - So the PC is a windows xp pro sp2 and office xp (2002). The file normally sits on a server share and whenever ONE client opens file - even when...

I have protected worksheets that I need users to update. (I unlocked the cells that I want them to use and kept the rest locked; then protected it.) When...

is there a way to conver the Excel 2007 travel expense calculator to use in the 2003 version of Excel?

I have many worksheets in a shared workbook. My users will input data on any or all sheets. I would like the sheets to automatically sort (by 3 columns -...

I am using Excel 2003. I have three different sheets-Sheet 1 through Sheet 1 (3). what i am trying to do is to add a particular cell from all 3 sheets. I...

I use to be able to create a pivot table from an external paradox file and it doesn't appear to work in Excel 2007. Anyone know if I can do this or not?

I have a Totals workbook with 52 sheets for 52 weeks of the year, the formula in the cells are linked from cells in an input workbook. Somehow, I have...

A data application saves numerical results as Excel .csv files into different Windows folders (as sub-folders within a main folder) every time that it runs....

Data recorded in col A is called for in Col G. So that blank cells in A do not deliver zeros in col G, I used =if(A1="","",A1). Thanks Dave Peterson. I total...

I would like to trasfer a number from a cell in one file (worksheet) to another and keep populatiing the next cell. I wanted to use a command button to...

I would like to create a VB-program to import data from other workbooks in different places. It is not possibel by recording a VB, because you just have to...

I have a large daatasheet with integer. After each group of data the average is calculated and the results are introduced as decimals which starts from...

I have a bunch of cells which contain a reference but are missing the = sign how can I add the = sign to complete reference in one go instead of one by one

When I right click on the mouse button in excel, I no longer see any functions/menus come available (no copy, paste, etc.). Was wondering how I might fix...

I know how to get the last cell in a column: range("A65536").End(xlUp).address for the row number range("A65536").End(xlUp).row for the row number but I am...

I have a list containing 18 different categories. I want to create a user form that allows the user to select multiple combinations of these categories -...

Using Excel 2003 on a networked system, adding/editing text in a drawing object and charts is made difficult because once I've clicked on the object with the...