I have three column in my excel sheet 1. Month 2. year 3. Amount 4. Period In period column, I want to show 1. if the month is current month it should be...

Before I can carry out other task, I have to line up the row where Date 1 starts with Date 2 for all other stocks. It is not always 3 rows down as shown...

I am using the following formula to obtain the number of calls for a period of time: =IF($M346="Outbound...

I have the name of a tab within a cell. How do I use this cell to look up data on the tab. Tab 1 has the following entry:- Road 1 I wish to use this entry...

I've recently been looking into cross-sheet dependencies and trying to write some code to identify where the limits have been busted (i.e. what's causing...

I want to specify a text color as the look up value in the vLookup Formula. Is this possible? Do I need the code of the color? Thanks in...

Hi thanks in advance, Every time I open up a pdf through email etc, Excel opens it up in excel. How do I stop this from happening? All the PDF's show in the...

Hi, I have a peculiar problem. when i open an excel report in MS Ecel 2003 and print preview the sheets. The fonts appear in different colours. That is, the...

Hello group In one PC of mine that have the Office 2003 version the excel had this annoying problem of excel macro notification Security Warning Macros...

Hi, I am wondering if anyone can help me, I have a range of dates with information attached to them, i am trying to figure out how to show only a selected...

I have an Excel 2007 spread sheet where I enter information on one sheet, and the ‘data’ is stored on a second sheet in the same workbook. The transfer...

I am using a very easy formula to add certain numbers across a spreadsheet. It has worked fine for each line until I reached one line where the formula...

Does anyone have any suggestions on how to avoid the pop up message for updating links? There is value 123 in cell A1 under file1.xls, and There is a cell in...

Hi there, I have three colums of data in a worksheet from A1 to C5, example; Column A Column B Column C ABC 5/2/10 02:00 Dog DEF...

Does anyone know how to set up support in Excel for dual screens? The only way I can seem to get it is by having two Excel sessions running. Word is much...

I have problems finding the correct formula for my Excel problem. My spread sheet is used for statistics for my web shop. In column A I have values...

Hi, I have problems when the look up value in the vLookup formula is a date, and the cell has a differente format. For example, I specify 03/03/10 as the...

Hello group In one PC of mine that have the Office 2003 version the excel had this annoying problem of excel macro notification The workbook contains a type...

Really need some help with this one as I am stuck. I am trying to use a drop down box and a name range to get monthly totals and can't figure it out. Here is...

Is there a way to automatically insert national holiday dates in an Excel sheet? Thanks in advance. Regards Emece.-