Alt-Enter works fine to create a line break in the middle of a cell. The problem I run into is when I link to that cell somewhere else in the workbook, the...

I need to organize data into 6 different positions on a sheet, and the data is formatted like this... name|date|Starting time|End time. There are 6...

Excel 2003, SP2 I have a spreadsheet with cells formatted as "General". They repeatedly revert back to "text". I also have conditional formats which still...

Excel 2007 SP2. I succesfully created a connection to a SQL Server 2005 and can view all sql server table data in my sheet. I would like to be able to edit...

Having saved an excel spreadsheet I reopened it to find the numbering of cells down the left hand side of the spreadsheet and the letters at the top of the...

You can only add 7 conditions. What do you do if you have more then 7? Is there another function? Thanks, Kristin

I can export data from my mrp system, however the date an issue occured has a timestamp which is DD/M/YYYY HH:MM:SS What i want to do is be able to...

I'm trying to calculate difference between dates, but with a twist- I need to return the number of full months between beginning and end dates, then, in the...

Hi All I have an XL spreadsheet labelled 'English' in which is a contact list of all contacts that speak English. One column is labelled Country. I want to...

I am trying to copy and paste a block of cells from one workbook to another workbook. The original file is formulas and the destination file cells need to...

If I have a filter on column "A..G" and then I filter on ecolumn for x criteria... I do subtotal (9,A5:A200) it will only add up those meetting the filter...

I wish to create a subtotal in a filtered list, which I know I could do using the =sumproduct formula. However, I would like to know if it is possible to...

=IF(ISNA(MATCH(B1,Sheet1:Sheet2!B:B)),"No Match","Match") This formula searches to see if (X) is on sheet 1 or sheet 2. I need it too search sheet1 and...

I am trying to create a button or check mark so that when a user presses it a number will appear, but when they 'deselect' the button or check mark that...

In Excel 2007, cells with date or general formatting sometimes change to Euro currency formatting. It happens randomly - sometimes once a week, sometimes...

This is very complicated! I have 3 different spreadsheets that I need to link data from. Sheet 1 is Active Sheet 2 is Holding list Sheet 3 is Non...

Hello, I have been given a list of members to our organisation and each has a full birthdate attached, we would like to send them all an electronic birthday...

Hello, I am trying to link a column in one spreadsheet to another spreadsheet. When I initially copy and paste special everything copies over well and if I...

Hi, i have this macro: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Sh.Name "SEARCH" And Sh.Name "PLANNING" Then If Not...