I need to prepare a six month P&L for my small business. Are you aware of a standard Excel template? Please post url and filename to download. Thanks

I am trying to protect formulas in an Excel spreadsheet but my tool bars in Vista are different. Can someone help me to protect formulas so they can't be...

Hello, I have a list of activities by department, and I want to show only the top 10 highest savings across user input defined categories. For example, one...

For every row that contains the word "employee", I want to color as yellow. I know conditional formatting is what I should use but need help. Thanks!

I am trying to use vba to copy a range from one file to another. The old file is a log of dates and times, and the new file is an updated version of the log....

I am trying to creat an ordering form that has several criteria/options that have to be matched to allow other options. I have a dropdown box that allows 4...

I need some assistance in creating a formula for dates. What I am trying to do is create a project time line based on workdays Mon - Fri plus...

After a recent upgrade I'm having an issue with cells that are formatted as numbers with 0 decimal places. If I key in a number of 4778 when I exit the cell...

Hello, I have data in an excel sheet as per the below appended table. Now I'll be updating the actual data every month in a different sheet; hence I require...

I am trying to create a field in a form with a pop up calendar. I tried inserting the calendar control but need the calendar to disappear when date is...

I use to think I knowe a lot about Excel - but as people ask "can you do this?" I dont know as much as I though In the valiation source - can a formula be...

I have a clock running in Excel. Data in one cell is constantly changing. At a specific time which I specify in a cell, I want the value in the cell that is...

I have a row that contains days of the month - cell I3(DD). I want to read the cell and change to to the day of the month - cell AE1(MM/DD/YYYY) using...

Hi: I want to use the CTRL F (find funtion) with 2 files. One file called "data" has a list of about 10 companies and the other file called "stats" has...

Excel 2007 freezes when I try to sort or filter an Excel 2003 file. The 2003 file is fine until I try to sort and then it gets stuck and I have to use Task...

I have a HUGE database that I've been working on since August 2008. The last time I accessed the file, December 2008 - all was fine. Now when I open it, I...

Using Excel 2003 - Is there any other way to simulate a check box in a cell? I have a form that I want users to be able to check a box for a certain request....

If cell c3 is a negative value how do I colour c4 automatically?

I created a print macro in Excel 2007 which looks like this: ExecuteExcel4Macro "PRINT(1,,,1,,FALSE,,,,,,1,,,TRUE,,FALSE)" This needs to work on an Excel 97...

I somehow have lost the default blank worksheet that opens when I launch Excel. How do I reset my settings to open a blank worksheet every time Excel is...