Hi, i need the sum of all the times but calculated by a person name. Ex: sheet 2 A B C nr name time 1 john 00:02:00 2 mary 00:01:00 3 ...

I'm getting an error that says too many cell formats. There is a 4,000 limit in excell

Very few people know about this feature in Excel 2003: hold the shift key in order to get to the file copy-as option. For those of you that do, was this...

How do I enable cookies ? I cannot download Excel from My Documents. On person has suggested it might relate to the Excell version I am running, how do I find...

I have opened up a file using the following code: Dim fName As String fName = Application.GetOpenFilename() Workbooks.Open Filename:=fName Then I...

Excel 2007 on XP I need to work with multiple workbooks and it gets to become a headache having to switch between them using Tb+WindowsKey. I want to be...

I am creating a pivot table on a data set that is 32000 rows and 10 columns. Once I set the layout and select the fields I want to summarize and click...

Normally when you create a named validation list that contains a blank line, you can choose from the list or enter anything at all because of the blank. I...

When I start Excell 2007 a message tells me it cannot find Appointment Calendar.xlt. This is because I stupidly removed it in an attempt to preven it from...

I want an easy way to take the following data set: 1 2 3 4 5 6 7 8 9 and turn it into a single column of data like this: 1 2 .... 9

I am looking for a macro to delete an entire row if a cell contains certain words or is blank. Thanks.

Is it possible to freeze pane a column and a row on the same excel spred sheet -- grizz

I would need to have an automatic update of filter, is it possible? The situation is the following: I have a questionnaire with 250 questions, depending on...

I have created a workflow in SharePoint and am having my managers digitally signed the excel file. However i'd liek to be able to email the signed file from...

Help ! I would like to have data that is automatically provided to be automatically filled in for each day that a person that works. On my new worksheet, I...

Hi, I have been working with pivot table for 10 years. I am now in Excel 2007 and I am trying to create a pivot table off of a range of data that has some...

I have a large file of 200,000 lines items. I am trying to copy 26,000 filtered items to another spreadsheet. I cannot copy and paste the visible lines. ...

Excel 2007 on XP I need to work with multiple workbooks and it gets to become a headache having to switch between them using Tb+WindowsKey. I want to be...

how can I autopopulate a specific range of cells if for example an option has been selected

I have 4 named ranges that are used as sources for data validation lists. On my worksheet, I have: 120 cells associated with a named range with 2 items, 60...