I want to search a range of cells, say C:C for a value, if that value is there i want to multiply the corresponding B cell and D cell together then sum up all...

Hi got a problem with excel. everytime I open a file the cells are formated in a date format and I have to reformat them. Any suggestions to solve...

I want to sort contract numbers in Excel the same way we do in our filing system at work. Our contracts contain both numbers and letters, but excel won't let...

We Have Anumber of excel files created in Macintosh Excel 2000 with graphs. These sucessfully open using Excel 2000 but all crash when using Excel 2003. The...

I am posting a few files sayb File A and File B (Excel 2003) on a network drive. These files are password protected and are linked to each other where File A...

I want to format groups of cells with a different color according to the day of the week specified in one of the cells. Conditional formatting allows only 4...

I am the accountant for an insurance agency evaluating Office 2007 Small Business Trial Version for upgrading our workstations. Our agency accounting...

Hi there Does anyone know how I can have six cells next to each other, using the =RANDBETWEEN(1,49) function, where none of the cells equal each other? I.e....

Hi, How can I use "shell" to move from Excel to the current (default) web page to copy some comma delimited text data, then open Notepad and save it there? I...

Convert existing Excel into Data source document to link to existing Mail Merge document to create multiple letters for mass mailings?

I have 2 Excel files. One named "Actual" and one named "Budget". In each file are tabs for the months of the year, "Jan" "Feb" "Mar" etc. The Budget file Jan...

I need to change case from Lower to UPPER for a range of cells. Any pointers on this will be appreciated.

Almost done with my macro! :) Initially, I place my curse in a location. And after a few moves around the macro (Hard coded and Offsets) I want to return back...

We have a client that does not want to see the formula in the formula bar. I decided to protect the excel report and hide all formulas, but that is not good...

I am trying to write a bit of code that will look at a cell and covert what's in the cell to some sort of code. e.g. Hello Goodbye Yes No The above...

Hi all, I need to concatenate a word and a number cell. eg, Concatenate("Limit = $",A1) where A1 = $100,000. It shows up like this: "Limit = $100000". However...

Hi, Im using Excel 2002. In paste special "Column Widths" option is there but "Row Widths" option is not there. Is there any reason why it is so. Regards,

Yes, this is almost identical to my earlier post about "SUMIF" not allowing formulas. Everyone was so immensely helpful, I cannot help but ask another...

How can I force users to save via a macro which strips away sensitive data before saving? Don't want them to be able to use SAVE or SAVE AS to save the...

Currently I have a workbook named "new job" that sales reps open to input a new job. there is a command_button on the S-1 to "Save job" Sub...