How do I prepare a cell with a formula, but keep it blank until the information is added to activate the equation?

I am using the WORKDAY function and it is working correctly, however when I copy the formula to another cell, it changes the Holiday cells. Is there any way to...

Hi folks, I'm fairly new to the "joys" of Excel and would appreciate some advice. I have a multi-sheet workbook. Each sheet has a cell (the same cell...

whats the best way to get a good command over Excel for people who use Excel to perform normal jobs and know the basics of using Excel.

I want to create a macro in Excel 2000 using one already written by someone else. but all I find are instructions to create one from scratch the normal...

I built a list box (yeah), it understands words, but not colors. All I want is it to show "status" colors (red, amber, green) I just cant figure it out. Thanks...

ow do I add 42 dyas to a given date, not including weekends or specific holidays?

I am trying to set up a spreadsheet that has a summary sheet collating information from other worksheets in the same workbook. However, whenever I insert a...

Some clients have closed files and some are closed in the worksheet. I need to create a report that includes all the info from the open files only. The status...

1. Please how do I open a file saved as Dbase 4 version in MS Excel 2000? 2. How to open a file in MS Excel 97 in MS Excel 2000? 3. How to open a file in MS...

Creating a simple invoice in Excel. Want to assign unique number to each invoice, sequentially as each is created.

Hi folks, I have a multi-sheet workbook. Each page has a sell containing a total - let's call it "D2" again... :o) I want to take data from cell "D2" on each...

How do I set up a spread sheet for a small business expense/income monthly statement?

Could someone please suggest how to use a worksheet function to count the number of non-empty cells in one column when the value in another (date) column is in...

Hi, I have a book of Excel formulas that gives the following formula to shade alternate rows in a Workbook: i.e. so the rows look grey, white, grey, white,...

I have a lists of items in rows 1 through 22. Each item is listed individually and has a 1 in the quantity. When I total the column using the sum function I...

Thanks for the help. I like that way a lot better. I actually got a formula to work, and it probably follows along with the suggested earlier. It is written...

I tried to search for this solution on the web, but finally gave up. Here's what I want to do In a cell I have a users First and Lastname (yes both in the...

I am making a phone contact record for work. How can I make a cell (with a customers name in it) expose more details or information about that customer, when...