Is it possible to copy and paste a conditional sum formula to a different cell location and then change the = to value in the IF( portion of the formula? I...

I would like to be able to superimpose a 25% gray "Draft" to draft documents. Any idea how to accomplish this? TIA Lacreeda

I want to stop the invoice template from prefilling today's date everytime it opens an invoice. Does anyone know how to do this?

HI, I have a file that has all the data names and numbers. Then I received a smaller list that only has the names. and I need to match the rest of the...

I would like to have a Macro to go to a certain cell to rename a worksheet. When I run I get errors. Can someone lend a hand?

I would like to add a field, or a column that will indicate the date and time that the corresponding row has changed. For example, I have the following...

If I divide my worksheet up into 2 panes, how do I perform "unsynchronized schrolling" Thanks

Have a look in HELP index for INDIRECT "toomis" wrote in message ... hi, was wondering if...

Thank you for your help I used the formula you suggested and I'm getting the #VALUE! error - Any suggestions? -----Original Message----- One way would be...

We have a worksheet with macros and every time I try to run them the following error occurs with name of the doc in the brackets. macro error at...

Hello all: I need to rearrange my columns into rows. I've got column headings like this: Heading1 - Heading2 - Heading3 - Heading4 Data1 - Data2 -...

This is driving me crazy! If I want to "lock" a cell in a formula so that Excel goes back to that same cell when I copy the formula how do I do that? For...

I am having trouble reproducing the values produced by the Data Analysis tool that calculates a variance-covariance matrix. When I try to calculate one cell...

Hi, I have a list of cities (more than 2000) stored in a column. What I am trying to do is for a user to enter the first few characters of a city in cell A1...

I'm trying to get cells to format minutes and seconds ( I always get AM & PM when I format the cell under "time"). I'm trying to add minutes and seconds to get...

I opened a file. Did not make any changes. When I close the file, I receive a message asking if I want to save changes to the file before closing. I didn't...

The IF function may be used to place a blank value in a cell based on a criteria. Example: =if(iserror(vlookup(a1,table,2,false)),"",vlookup (a1,table,2)) The...

In Excel 97 there are two types of Text Boxes those that are created by the Draw toolbar and those that are created by the Control Box toolbar. One seems to...

When I filter my spread sheets and then try to access the alternatives in the drop down menu the font size takes the text outside of the field of view. How can...

I have 3 columns in XL, A, B and C. A and B contain variables like region code for A and salesman ID for B In C, I have amounts. I would like to add amounts...