I'm finding it difficult with conditional formatting matching the month for =today() in cell b2 for example. the purpose is to match the month for a date...

How would I look up a value in a list and return multiple corresponding values and then add them up? A B C Paul 155 Pauk Jake 34 Paul ...

Hi, I feel like an idiot but I have the instructions on how to do this... It seems pretty self explanatory except that the first step says "On the Options...

Hi, I am using Office 2007 and I have noticed something strange. My workbook is quite simple and not very large (300KB). In the most busy spreadsheet, I am...

i have a list of names in excel in columns. i would like to have the number plus the name to show up on anther sheet that looks like a map. how do i do...

I have a spreadsheet that was sent to me and the "wage" amount does not have decimals included. I want to add a decimal to all of the wages, but not for sure...

I am using Excel 2007. I have a list of names in column A and email addresses in column B. I want to create a macro or something that will allow me to...

Is there any way to alphabetize worksheet tabs with excel 2007?

I have an excel worksheet were some cells are merged with cells in other rows, and other cells are not merged. Specifically, the cells with titles are...

I have an excel file with the time of appts. Appts are scheduled at 5 min intervals starting at 7am and ending at 4:30pm. (i.e. 7:00, 7:05, 7:10 etc.) I need...

Hello I made a listbox using the control toolbox option but every time I "save as" and open the spreadsheet, the size of the listbox changes. It usually...

Hi, I have Excel 2000. Once I created a pivot table, I used to be able to format various fields as currency or percentages and hide totals. I would hover...

I have the following data in columns B and C, respectively: B: Occurances, 3, 3, 2, 1, 4, 4, 2, 4, 3, 4 C: Name, adam, brad, chuck, dale, ed, frank, george,...

Using a spreadsheet book I am using multiple tabs. In one tab I have a drop down list of "Customers", "Sales Price", "Quantity" and "Products." I have...

Is there a way to compare two excel files to review changes made between them?

I have several different workbooks, all with data and charts on one worksheet. I would like to compbine them all into one workbook. I don't see how I can do...

Trying to do.. With ActiveSheet.OLEObjects.Add(ClassType:=Forms.Image etc... .Name="TmpImage" Then ActiveSheet.OLEObjects(TmpImage).Delete Want to...

It is probably easier to just ask for what I want than to describe it but here goes: Say Column A is a column of integers; Column B is a single lower...

I have a set of dates and times in a schedule that are compared to holidays and conditionally formatted (changes text color) if the date is a holiday. There...

Its free. Its had all the macros and VBA removed, so Excel won't shout at you when you try to open it. It just a plain old everyday XLS file, no fancy...