Hi all I have a spreadsheet with dates in row 3 going from today till the end of the year i.e 26/apr/2010 In row 16 directly below the date i have a number...

We have a spreadsheet that subtracts one number from another. We did not understand why Excel is rounding the way it did so we decided to add decimal places...

In my workbook I have multiple sheets. I have a summary sheet, called: Graphs, consisting of (only) graphs, build from the data from the various sheets. These...

Hi, I would like to ensure that a user can only input one of the following numbers in a cell: 1, 2, 3, 4, 5, 6, 7 or 10 I'm using Excel 2003. Thank...

I need to permanently save a header and it will never save once I open up a new file. Any suggestions?

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...

G'day Guys, I have a few hundred workbooks in a folder (each containing only a single sheet) which contain information in the cell range F12:G40 What I'm...

Hope I can explain this clearly. If this, or something like it, has been answered before, please direct me to the post. I have a worksheet in which I need to...

Would anyone know how to refer to a string inside the formula property value? In my case I am checking a named cell to see if it is holding a specified string...

Have a workbook with numerous worksheets in it and one sheet as a data source for WORD mail merge documents (two). Question is: Is there a way to have a macro...

I have created hyperlinks between Excel 2002 spreadsheets in different directories. When I open the spreadsheet in Excel 2000 the hyperlink is not good. It...

Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on...

How can I create a macro or conditional formula to remove columns containing all zeros

Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please Hi, i have 2 workbooks, 1 the macro's are password protected so i...

I have a spread sheet built that currently has 382 sheets of data. The sheets are 12 columns x 61 rows. There are conditional formats applied. I can copy a...

I am trying to share a work book but the feature is grayed out, not sure why - pls explain

help needed please........ I am not a formula expert so bear with me please. I know filtering is available but I am trying to save effort as data goes into a...

I would like to know if there is a way to get the "&" name to appear in a cell on the worksheet itself, instead of as a header or footer. Any ideas?

I have the various dates on which our staff have joined the organisation. I need a column that would convert all the year part of the date into the current...

Hi, Is there a way of using the CHOOSE function if you have more than 29 values? AND Is there a way of avoiding typing in all of the 29 (or more) values into...