General

Reduce balance
How can i get the cell with my balance owed to subtract what payment I made on the next cell? -- nat ... 11 Mar 2010 20:15

Pivot Table Variance
I have a pivot table that shows gross revenue by month. The months are the column headers. Is it possible to create a field within the pivot table that shows the variance between January and February's gross revenue? I don't have access to the source data. Thanks, Nate XL2003 ... 12 Mar 2010 05:03

Microsoft Excel Merge Cells
Hey Guys, I work for a Marketing company and every week i am inundated with data to present in a clear and concise way to board members. I have cells that are presented like this: 10 11 12 13 14 10 11 12 13 14 10 11 12 13 14 10 11 12 13 14 20 21 22 23 ... 11 Mar 2010 15:44

Automatically Update Excel Links
I have an Excel spreadsheet that resides in SharePoint. Every time the spreadsheet is opened a message appears asking is links (within the spreadsheet) should be updated. Is there any way; using formulas, VB Code or some other magic :-) to have the spreadsheet automatically update and to have it update every ... 11 Mar 2010 14:36

Tabbing between text boxes in Excel 2007
I have a spreadsheet that has multiple text boxes that I need to quickly type info into and then tab to go to the next text box, this worked just fine in 2003 but since I changed to 2007 it does not allow me to tab between the text boxes, any solutions? I would be happy to send someone an example of my workshe... 11 Mar 2010 19:08

filter a list of numbers
I have a list of numbers (20000 to 27583) I only want to see the info for the rows where the number ends with 0 (eg. 20000, 20010, 20020 etc. basically every 10th row) When I custom filter for "ends with" 0, my whole list goes away. ... 11 Mar 2010 18:01

Formula to add up numbers but there are negatives
Hi, I want a formula that will just add up the total numbers and disregard the negatives, is there a true value formula? ... 11 Mar 2010 13:28

Excel character limitations
Hi I'm trying to copy between 2 excel spreadsheets, when i do, the end column, which contains more than 255 characters, has the end chopped off. How can i increase the amount of characters that I can copy? Any help would be appreciated. Thanks! ... 11 Mar 2010 13:28

Address of Freezepane
Hi all, In VBA, is it possible to determine the address at which a sheet is locked? I found a property activewindow.splithorizontal and splitvertical but they give me double length integers. Anyone know how toconvert this int an address? Kind regards, Bony -- "There are 10 types of people in this world.... 11 Mar 2010 13:28

Excel clicking selects multiple cells instead of a single cell
Excel clicking selects multiple cells instead of a single cell ... 11 Mar 2010 13:28