For aircraft maintenance that is due on the last day of a month, 24 months from a given date... how can I do it? The FAA requires certain items...

friend sent cd with spreadsheet data using office 2003 excel and I need to load it to my (c:) on xp 2002 excel How do I get this done

060124 5pm PROBLEM: Excel Equation Function / Conditional Formatting Dropout Having some problems with entering data. Symptom is when enter data in...

Hello, Can someone tell me if there are keyboard shortcuts for the following commands. a. Paste Special - Values b. Paste Special - Format c. Insert -...

I have a project that is getting more complicated than I had anticipated. I have a worksheet that has an input box used to input initials. The employee inputs...

I want to create a cell range that will be based on the value of a cell so that i can change the value of the cell and the range will lengthened or shortened. ...

how to find negative figure in various columns and rows

I have a problem in that I currently run a macro that opens all the workbooks in a particular folder, and merges the data onto one new worksheet, which works...

I have one interesting question :D I have one sheet = sheet1 A1 = (input date) would be: 01 of any month (something like 01.01.2006) A2 = would be the last...

I have a project with 56 worksheets, most based on the weeks of the year. I have a formula advising what week of the year I am working on and returning the...

My boss liked an invoice template I made but wants the spacing between some of the two lines in single cells to be reduced. Is there a way that I can take two...

This #n/a is giving me some troubles in my formulas.. is there anyway to hide this in the...

Usually on Excel when you press the arrow keys on the keybord, it moves the highlighted cell box. Something has now changed so that instead of doing this it...

How can I track attendance in ecel with a moving quarter? The following is an example: Employees will receive one (1) point for each full day absence...

Looking for tha optimal settings for the following. Do not see a reset. Thanks. Tools, Options, Calculations: - Max. Iterations: ? - Max. Changes: ? I see...

Hello everybody, I have a macro that does not work since the sign "" appeared in the title menu. The macro is on my hard disk and do the job on a downloaded...

Hi, I have 3 sheets whereby sheet 1 is linked to sheets 2 & 3. If I type some things in sheets 2 & 3, cell C36 in sheet 1 may or may not change. If it changes...

I know I done this before but I am drawing a blank. I am exporting a report from Crystal Report. I the column contains negative figures. In Crystal I can...

I'm currently using the following formula to calculate certain cells in the range only if they match in two columns. It works fine for getting a...

I have compiled a spreadsheet which uses the following dependant validation formula. Is there a way to copy the validation & it's formula to all cells in that...