Hello, I would like to ask for help with a worksheet. There are two cells I need help with. These cells list vehicle VIN Numbers. One column was reported...

I have a column of names I need to sort. Unfortunately, some of the cells have 1 or 2 leading spaces, which cause the zero-leading spaces to be sorted, then...

i get the error message "this operation requires merged cells to be identically sized" i have checked several times and the merged cells are the same size. i...

I am using the following script to hide or unhide rows. How do I code the offset to only work when a row is being unhid. If we cant do this only offset...

-- Thank you for your help. FMW ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To...

I have a spreadsheet with rows 1 & 2 and columns numbered 1 & 2. In column 1 I have the ability to click a plus sign (+) to expand information in hidden...

How can I automatically start a macro when a specific .xls starts up?

I have to create a vehicle service record and I wish to have the service interval of 6000 miles automatically added to the current milage.I wish to do this...

I'm trying to create an IF formula that returns data after searching a cell that contains more than one data range. For ex: Cell B3 contains GCVW-00001,...

I have a worksheet of data that is dumped from our ERP system. It will have cells that look blank but actually have "spaces" in them, alot of cells look...

I have a few questions:- 1) I am running the following macro to look through my spreadsheet, and every value 0 in the range it produces an email. However the...

I am trying to write a formula to show the last working day (working days are Monday to Friday) of a month based on the date in the previous cell. If A1 =...

I DESPISE MICROSAFT OFFICE 2007 All i want is a simple way to get answers to my questions BUT NO I end up here with no answers and still frustrated as...

Is it possible to have a calculation in a form field to add two numbers together and then dump in the table?

I am using the following code to hide or unhide rows. How do I get this formula to perform the activecell functions only when unhide is being performed? ...

It appears that Excel 2000 does not like any year after 2009, as it tells me date is invalid. Is there a way to fix this ?

Hi! I've managed to link fileds to an other excell document. IE. ='C:\Page1'!A1 But now I'm trying to build a link so that it updates with a new year every...

Is there a way to create a blank, quartered pie chart in Excel that I can shade by quarter as needed??

I am told that as long as my Excel is in "compatability mode", the passwords are very easily discoverable. How do I get rid of that "mode". Thanks.