I want to have missed due dates automatically highlighted using conditional fromating. Example: A1 is due date, dd/mm/yy A2 is completion date, dd/mm/yy If A2...

For exporting, I am trying to insert an apostrophe in each cell in one of my columns that contains numbers. There are over 800 records, how do I do this...

Normally you set up as A1 = 1, 'value if true', 'value if false'. Can you set one up such that A1= "Text" if A1 contains "Text is a value" I've tried...

We use a numbering system to sort certain data, i.e. 2007-1 where 2007 is the year, 1 is just a number - it could go up to 1000 2008-1 same as above. How do I...

My version of Excel 2003 has a print default of "Print entire workbook". I tried to create Book.xlt and Sheet.xlt with "Active Sheet", but it didn't work. ...

Hi I have a mathematical puzzle that I cant solve. In the table below, the inputs are the values in columns "A" and "B and the desired output is column...

Hi All, Why a horizontal range, e.g like A1:G1 cannot be used in ComboBox ListFillRange? Is there a workaround for that? Another question: can an OFFSET...

How can I get the “� and “� symbols act as part of a number on a formula? I work at a lab, and when we get results that our equipment can not...

Fee list per term Code description Code E (student yr =1) E (student yr =2) E (student yr 2) O (student yr =1) O (student yr =2) O (student yr...

I want to embed a custom menu in an old (working) spreadsheet. I have downloaded a number of pre-written solutons which all work when used in the original...

Hello, I have a list of maybe 20 or so $ amounts on an invoice that I need to figure out which combination of these #s add to a total of $151.60. I thought...

I need a formula for the following: If D6=STG, then place "IMC COE" in cell D7 If D6=SWG, then place "SWG IMC" in cell D7 If D6=S&D, then place "S&D IMC" in...

I have a userform which has a textbox15 which I have formatted to dd-mmm-yy by using the following code: Private Sub TextBox15_BeforeUpdate(ByVal Cancel As...

I'm brand new to Excel. I'm trying to enter financial data and manipulate this data. I tried using AutoSum on my first batch of data but don't see the result...

Hi, Is it possible to format cells so that Excel shows the data to 3 significant figures? (without having to introduce a formula in the cell) the best I...

I am trying to sum totals from 19 pages, I have entered 2 dummy sheets at the beginning & end & now want monthly totals. each worksheet has monthly totals...

I have been searching in the groups for an answer but can't seem to find one that fits my problem... so apologies if you have said this a few times before. I...

In a table with dimensions and quantities such as: 45w - 30h - 10qty 30w - 45h - 10qty 45w - 30h - 2qty 45w - 30h - 8qty How can I get a total quantity for the...

I have an excel table which contains a list of products. One of the columns contains a list of hyperlinks to each product's picture, on a certain website. I...

Hello! Excel 2003 sp2 and sp3 do not remember the macro security level. Excel returns the level to low after any change of the level. How to prevent a macro...