General

Checkbook Register
I like using the checkbook register template in MS Excel, but I want two debit columns and two credit columns against the one balance column. I figured out how to copy the column, but it does not calculate in the balance column. How do you do that? ... 25 Apr 2006 19:17

Dashboard
I am not an expert at Excel, but can do a few things --- the one thing that I cannot do is create a web-based dashboard using Excel. What I would like to do is create a dashboard from one like you see with flahing red, yellow & green lights something that looks dynamic. It would be great if the dashboard coul... 31 Mar 2006 11:18

Converting QIF to XLS
My bank only allows me to download in a .qif format but I use Excel to track my finances. Can anyone help me convert these .qif files to .xls files so that I can use them in Excel? Thanks! ... 31 Mar 2006 10:11

resetting last cell
In a blank Excel 2003 workbook, on sheet 1, I entered the number 123 in cell A1 and in cell R50. My used range thus was A1:R50 and my last cell was R50. I hid the rows and columns beyond this area, i.e., rows from 51 to 65536 and columns form S to IV. When I unhid the rows and columns after using goto A65536 a... 30 Mar 2006 20:20

XIRR and negative IRRs
I had a series of CF's that should produce a negative IRR (uisng the XIRR function). However, the excel XIRR answer always goes to 0.00%. When I force to periodic payments and use IRR funciton I do get a negative IRR answer. Is this a XIRR issue? ... 27 Mar 2006 23:35

need help please....
I have a problem that I can't seem to solve. I'm trying to create a macro, or find some othe way of automating the unprotecting the worksheet, clearing of all non-protected cells on the worksheet, re-protect the worksheet with no password, and move on to the next worksheet in the file and do it again to the end. The... 27 Mar 2006 06:22

I need help with a formula
I want to find the information in column 'A' after finding the referenced cell i asked for. My search is for MS35206-230 but I want Column A returned Example Col A Col B Col C .05 Red MS35206-230 -- MrSales ------------------------------------------------------------------------ M... 17 Mar 2006 15:49

MSN MoneyCentral Stock Quotes add-in (msnsq.exe)
Is there a limit to the number of stocks being updated in Excel? If so, is there a premium service to update several thousand stocks? ... 17 Mar 2006 10:03

Percentage formatting
Is there a way to format a cell that has a negative % to be (100%) vs. -100%? ... 17 Mar 2006 10:34

How to prevent users from changing cell format
Hi all, I turn on protection on Worksheet with only Select unlocked Cells enabled. When I drag a cell and drop it onto somewhere else by positioning cursor right on the border it pastes the orignial cell's format (e.g., border and background colour) to the new destination. Moreover, the original cell was le... 17 Mar 2006 06:20