I am trying to insert (through VBA) a formula in certain cells. the cells in which the formula will go in will vary (i.e. it's a variable) and the number of...

I have a workbook with 5 sheets and macros with forms. When I select any one of the worksheets by the tab with the mouse, the cursor goes to a page and the...

I have an excel spreadsheet on a shared drive at work. When people in the office open the file, is there a way to make them "save as" and not to be able to...

Here's my problem. In worksheet 1, I have summation formulas in a one row, at a4, b4, c4, d4 and e4. I want to put the results of the above sum formulas into...

Hi, I have a row of cells. as below: Hol 8.00 9.75 9.00 Hol 8.00 10 9.25 9.00 8.25 I want to add the numerical elements in this row, but the text parts are...

I would like to put a button on a spreadsheet and run a macro that will bring up the save as dialog box.

How do I increase numbers in a range of cells by a percentage amount. For instance I have a price list on a spreadsheet and I want to increase each price by...

I have a co-worker who tells me he used to be able to any cell and make it equal another using the "=A1" type of syntax -- and then when he'd double-click it,...

didnt know where to put this so i thought here would be best, basicaaly i want to be able to compare 2 cells. For example say i have one cell with 1111000111,...

I have excel 2002 and need to shift cells down in a column without effecting the rest of the sheet. Please help

Hello Ladies and Gents. I am having a problem with VLOOKUP and Conditional Formatting. What I am trying to do is apply conditional formatting to the result...

Excel creates copy after copy of the same file! It doesn't open multiple copies, just lists them - makes looking through my excel directory for a partoicular...

After years of happily copying Excel formulae and/or results, I now have a problem. I'm copying from a worksheet saved in Excel 97. I'm working in Excel 2003....

Hello, I have a list of ten values. I would like to sum this list with the top 2 and bottom 2 values removed in the sum calculation. Any help would be...

Is there a formula that will change another cells information w/o having a formula in that particular cell. For instance, the IF(N5=Removed" then...

i have this equation =IF(NOT(ISERROR(VLOOKUP(A13,'C:\Documents and Settings\Gillian Mason\My Documents\MDA\Stocks'!$B$10:$D$320,2,FALSE))), which i want to...

Hi, I got a problem with a planning tool I've built to show how many extra sales are needed each month by my teams to hit a target and then an overachieveing ...

Hi All...... I have a 10MB Excel file that will "save" in about 30 seconds. As soon as I hit the save button, the Disk-activity light starts flashing. But,...

I was wondering if anybody knows of a formula to allow you to do calculations based on time. In other words, say I want to put a list of songs on a CD...

i want to make a cell (that is a list of two headings) change to if either one of two other cells are greater than 0 but revert back to if not.