I am trying to subtotal multiple groups within a list, e.g. I would like to subtotal sales by Product within Customers within Sales Rep. However, the...

This is a follow up to previous question. Any ideas anyone? Open a new workbook and protect all three of the default sheets. NOTE: be sure to check only...

Sheets "database" contains a large database with numbers in column B and dates in columns D-G. Each week we have an updated array (named range) that shows in...

Here is the template I am trying to modify. http://office.microsoft.com/en-us/templates/TC011684341033.aspx?pid=CT101441121033 I need a formula to check the...

I am trying to create a workbook with multiple worksheets that utilizes only one data sheet and has the formulas already in place so that someone else can...

Hello. I just bought a house and used the PMT and PPMT function to calcualate payments, interest, principal on my loan. Is there a function to calculate...

I am currently working on a bacarat tracker where you put in Banker, Player, or tie for my company, and need to see if there is a way for excel to give a...

Can you please help? How can I automate email alert when excel workbook get updated. When updated date is equal to today's date

In all previous versions of Office, I could copy the printable area in Excel (including charts) and paste special as enhanced meta file in Word with no...

There are many threads on this Forum dealing with merging tables, worksheets, and workbooks, but I cannot locate one that suits the problem I am trying to...

A B C ChoiceA ChoiceB Exp.Date X 11/2/08 X 12/4/08 ...

How do i count a range of cells that have a red character; like a red 0?

I have a list of outages at our cell sites. It is an Excel Spreadsheet with 1 row of dat per outage. The spreadsheet has 1 month of data and could be over...

Hi, I'm struggling still with a problem I have. It seems simple enough but as I'm fairly new to working with spreadsheets, I can't figure it out. You know...

Did something change in the way pivot tables are constructed in Office 2007, in addition to the obvious improvement in the onscreen interface? I am having a...

I am facing a strange problem in MS EXCEL. Whenever I open worksheets that are linked to other worksheets, I get a message "This workbook contains one or...

Hi, I am new to the concept of a Look Up - V or H - and heard that it may help me with my work. In short, I have a list of company names, addresses and...

I have a worksheet with an option for a user to choose "0" to "3" in a cell with a drop down list. Where "0" = N/A, "1" = NI (needs improvement), "2" = No,...

I have a spreadsheet with 12 columns. I'd like to sort on any one of those columns at one time or another. However, when I "Sort Data" on a column (it...

The delete and change name options on all of my excel worksheets are grayed out, I can't delete unused tabs or change the names of exsisting tabs.