I'm operating Excel 2007 under WinXP in a corporate environment. My PCs were recently rebuilt by my corporate IT department. Now, whenever I open an Excel...

I have a workstation with office 2003. In excel, i color some of the cells with a color (lets say a blue in the bottom left on the drop down), when I send...

I have a workstation with office 2003. In excel, i color some of the cells with a color (lets say a blue in the bottom left on the drop down), when I send...

I need to count the numbers of columns from A3:T3 which have any value entered in the cell. I also in another cell need to count the non blank cells but...

I have excel workbooks created in Excel 2003 that I exchange with others, some of whom have Excel 2007. With some (but not all) of those users, the track...

Hi everyone, I have an External Data Query set up (data that I take from an Access database with this query to excel). The query seams to work great but when...

I have multiple tabs in my workbook and I need to refer to certain cells and cell ranges in other tabs. I’m having trouble with trying to create a formula...

I use a lot of variables with subscripts. And would like the formatting to follow the output when I put these in formulas. i.e. =if(E180,"pr = 7","pr =...

The following macro selects precedents only if on the current sheet. Sub Macro1() ActiveCell.Precedents.Select End Sub If the cell contains reference to...

Hi all, I trying to develop a macro to print my worksheets. Here's the problem, I never know how much data my end-users will incorporate into any one...

Column A has a a list of letters (a,b or c) and Column B has a list of random dates. How do i get a formula that will count all letters of "a" that have a...

How do i create a diary template in XL, where i can enter (apart from normal scribbles) every day income & expenses. The sum of these should appear at the...

I have an equation average equation on sheet 3 but the data is on sheet 1. =AVERAGE(IF(paste_data!CL2:CL2000=1,paste_data!B2:B2000)) I want to continue on...

I get an error when opening an MS Query in Excel "Query cannot be edited by Query Wizard". If you click O.K all you can do is view and edit the SQL...

Helo, Please help me, when I run this code, there is no error message, it opens the worksheet, but it does not copy the data from the source range. This is...

When i open a .xls I chose to update values and get an error that the links cannot be updated. It only looks at two different files and when I go to edit...

Hi all, Another question on excel, how do i nest conditions together for AND, OR and NOT. So far, what i have is =IF (OR('A'!A1=X,'A'!A1=Y),'A'!B1,"")...

Can footnotes be created for an excel spreadsheet. While it is in Excel. Not after it has been converted to word. Sincerely, Robin Scott

In excel 2007, I have multiple columns of data. When I change the colour of any one cell, I would like any other cell with matching data to also...

In excel if it is a Macro file that it updates all related workbooks. I do not entirely understand this.