After copying a sheet with named ranges, I have the same names for different ranges on multiple sheets. As a simplified example, after coping a sheet...

The following formula is looking for "CSR" in either Col. D, E, or F. =IF(D3="CSR","CSR",IF(E3="CSR","CSR",IF(F3="CSR","CSR","NO MATCH"))) What it is trying...

I have a client that wishes to create a rolling spreadsheet. He would like information from one or more fields on a spread sheet to roll over to the next sheet...

when I copy and paste a formula from one cell to another. The relative formula displays correctly in the new cell, but displays the value from the first cell....

Each time I click on the chart on my excel sheet, I get a "char tool box" pop up. It happens on other people's computer as well. Is there a way to disable...

I have a present date that when entered should bring up an expiration date which is the first (1st) day of the sixth (6th) month "after the end" of the month...

Hi, Is it possible to run a macro to update pivot tables on hidden sheets in a workbook. I tried recording the macro manually when the sheets were visible...

A friend of mine constructed this function to lookup data on School Classes depending on the year. As a joke he input Bugger as the last message. He can take...

How can I create an audible alert sound in an excel spreadsheet. For instance, if column B falls below the sum in column A, I would like an alert (sound) or...

format using a custom format of 'mmmm dd, yyyy' without the apostrophes. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove...

I have several sheets, but not all sheets fill one page when printed. I would like to append those sheets that fill less than a page together, so when I print...

Good Evening and thanks in ADVANCE for looking at my problem. I am looking for some of the Forum experts to give me a hand please send me or reply with...

My self-esteem is in the crapper; I simply cannot imagine being "good enough" to help, darn it. Perhaps someone will recommend you try VLOOKUP. -- Greeting...

Happy New Year to all! Is there any way that I can show the date that the file was created in the header instead of the current date. I've been using...

How do I filter a worksheet to display only those rows that match a list?

Assuming that the names that you want are in Column A of Sheet2 and the address in Column B of Sheet 2, then in Sheet 1 B1 enter the...

I selected protection and unlocked all cells that didn't contain formulas. Then I set protection with a password. Problem: number entries can be entered in...

I am trying to achieve the following but have so far been unable to resolve. I wish to create: Multiple lists of 6 randomly sorted numbers from a selected...

How do you tell one worksheet to take Cell B2 fron for example CAT worksheet and then tell Excel to find a exact match on for example the DOG worksheet, and if...

I'm creating a report form in MS Excel 2000 that will use several formulas and conditional formatting. In a couple of sections, I've merged several cells into...