Column A contains various differnet values, each refering to the quantity of a particular type of product in my database. Column B contains the sum price for...

I need to measure the correlation between a large number of discrete series. To do this quick, I did the following: (1) Created a unique range name for each...

Hi, I have the following macro written in spreadsheets to protect them, however, in some workbooks there are 12 month tabs & a 'workings' tab. in the...

Hi I am looking to copy the contents from one cell to another depending on the font colour. ie if i have information in cell A1 which turns to red then the...

sing Excel 2007 - Trying to write a conditional formula for cells that have either text and dates i.e A B C D ...

if you have a multiple worksheet document and the printer defauls to mono and duplex but you wish the whole document to be printed in colour and simplex is...

How do I convert exam marks into grades using spcified grade boundaries?

I have a date (example: 4/1/2009) in cell A3. When I enter a date, I want the cell B3 to populate with the corresponding day. In this case it would be...

I have a range (R10:V14). Residing in the cells of this range will always be one name and the rest zeros. The name may change and/or move to another cell...

Hi i have a credit control spreadsheet containing credit limit columns from which i am working out credit terms. i have inserted a column into which i was...

Hi, I have large worksheet with data. We are packing goods and one row can be packed in several cases. I would like to form worksheet with static header and...

I have a workbook with several worksheets that is fed data from Access (via a worksheet in the workbook called "rawdata". I have a formula (shown below) that...

Hi, Thank you for your help, need som additional help: I would like to be able to change interest-only term (B4) to x, y, z months, then the loan repayment...

Hello All: I would like to know how can I find out the folowing. I have a chart like this: Type Company 1 Company 2 Company...

Hello every one, I am still trying to wrap my mind around array formula, this is my challenge now. How do I count cells with specific value?...

Hello all: How can I use a formula to insert a date in a cell the last time something was used. I have in chart which I enter codes. For E.G. from A1:A10 I...

Hi I have values in a column of cells, A1, A2, A3, A4, A5, A6, A7, A8 and so on. Then I only want to pick up the value in A2, A4, A6, A8...., and put them...

I have a spreadsheet in excel 2003. In cell a1 I have a name for example:Smith,Lisa In cell B2 I have an address and a phone number for example 1234 Anywhere...

When I enter a value in a cell of one worksheet, it is automatically entered in all of the worksheets in the same workbook, therefore corrupting data in the...

I am seeking assistance in creating a macro for the first time. I have two Excel files (File1 and File2). Column "R" in File1 is formated as text numbers....