Hello all, I have the following code: Sub DelOver16() If ActiveCell.Value = 16 Then ActiveCell.EntireRow.Delete End Sub

Every time i use 'Microsoft Office (2003) Doc Image Writer' (no printer at home) no printed document appears - ever!!! But when I try to reprint the document...

IF function if you omit the false parameter, the function returns "FALSE" =IF(A1="Bob",TRUE) so why doesn't it return "TRUE" so you can omit the true...

Hi! How to find repeated data and then merge and centre. My data is from A to M.Range from A1 to M4500 Any Function Or Macro. Thanks Hardeep

hello i'm trying to make a wage calculator in excel that works out your tax and NI ( UK ) i think i need to work a formula out on my topline but not sure how...

How can 2 cells have the same values, such that when I edit either cell the change is reflected on both?

Can anyone help please? I have a table of staff members and tasks set out as follows (the real one is a lot bigger) Task 1 Task 2 Task 3 Task...

Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last...

I am on salary (weekly) but always work alot more than 40 hrs per week. How can I make a spreadsheet that will calculate my rate of pay on a weekly basis, by...

is it possible to choose an item from a dropdown list which will enter a different value other than that chosen. Why I want to do this is as follows: We have...

Hi. I want a formula to enter into a cell - if A1 is "M" then I want C1 to be £8.00 or if A1 is "C or V" then I want C1 to be £2.00. Is there a formula...

What is the date function for November 25th, 2007 for Excel? TIA. Jorge

I have a massive master sheet that I need to break down into multiple sheets based on data. Here is what I have: 2: FIRST LAST BIRTHDAY PHONE...

New to this. Am using Office-Excel 2000. Have entered three columns of prices for company (List, Dealer, Distributor). Prices will increase next month. How do...

I want to display a range of quotes in one cell from a formula in that cell...if you can make sense of that. The first part of the formula works well and...

Bob, Welcome to my new thread. Bob's formula for the last work day of the current month (brought over from another thread WEEKDAY...

Hi All, I'm new to Excel ( and to this forum :) ) and so I hope somebody may be able to help me. I've got 2 questions.... QUESTION 1: I've got a spreadsheet...

I have a spread sheet with for simplicity 4 columns Column 1 is a Date Column, Column 2 is a Company Name, Column 3 is a Payment amount X Column 4 is a Payment...

CELL A1 has a number CELL B1 is the total (A1). As I add a number in CELL A2 I want CELL B2 to be the running total. Then I add a number to CELL A3 and I want...

I have a monthly expense I set up in excel. I have to go from office to office to different computers so if I add in an expense can or will the update be saved...