Sub uselastcellinL() Application.Goto Cells(Rows.Count, "L").End(xlUp) ActiveCell.ClearContents End Sub -- Don Guillett Microsoft MVP Excel SalesAid...

I am using Data validation in a sheet, that is working well as per my requirement. Now I want to use this with IF Condition. Mean if a cell has some...

Apologies if this is a duplicate - I posted a question yesterday, forgot to ask for notification of replies, and I can't find my original question! I have a...

I added a couple of columns to an Excel 2007 spreadsheet. When I went to generate a pivot table, all but one of the fields that I added do not show in the...

I would like to reference a cell to obtain a worksheet name rather than have the worksheet name in the formula. So rather than have Sheet1! in the formula I...

I need a column protected so it cannot be changed by just anyone, however, when I protect it, I cannot search for an entry in this column Any...

Is there a function in MS Office 2007 Excel that will 'invert a matrix'? That is, I want my columns to become rows and rows to become columns in the new...

Hi i have a list of dates ie 01/02/09 03/02/09 ...

I use a spreadsheet that comes up with values, or worth, of items based on many preset conditions. I want to improve the spreadsheet by adding a new...

Hi there guys, I'm relatively new to this but would appreciate your help. Basically what I am trying to do in excell to create visual alerts in the same cell...

I have PivotChart that is showing the number of opportunities of each type in each financial quarter. I want to include a bar to show the total of each type...

I am creating a phone list with telephone number for our employees to use when they are calling our clients. I want to prevent a phone number being entered...

I would like to record a command to bring me to a different sheet on the same workbook

The subject says it all; the function does not work for me in Excel 2007.

#1 I'm creating a time sheet and set it up for time in and out to have separate cells using the h:mm AM/PM format. In a separate cell I have amount of time...

I have a combo list (forms control) on an Excel spreadsheet, but the font is so small in comparison to the rest of the spreadsheet that I'd like to change...

I have an Excel Worksheet includes travel costs by employee by type of expense. These expense is allocate to cost centers based on the time each employee...

I compiled a large database of city blocks in an area. Now I need to be able to pull information from a city block by entering a street address on that...

Hi, In cell D6 I have a DOB entered....in cell E6 I have a datedif function that has 3 conditional formatting set as: 1 - If D6 is blank, E6 is blank. 2 -...