General

Need to move my page break down below my last data cell entry
I need to know how to move my manual page break down below my last line that has data entered in it. I am using Excel 2003 ... 2 Feb 2010 17:29

How to save a cube pivot as an offline dataset?
Hello, Is there a way to save a cube pivot as an offline dataset? I am hoping to distribute this file to the field so that users can use the pivot without being connected to the cube. Thanks in advance! ... 2 Feb 2010 17:29

Macro to paste hyperlinks
Hey ya'll, Real quick one, hopefully. :) In the below code, if I wanted to paste the values (shown), and then the formats and hyperlinks, what would I need to add? Would I add '.Cells.PasteSpecial xlFormats' and '.Cells.PasteSpecial xlHyperlinks'? If sh.Visible = -1 Then sh.Select ... 2 Feb 2010 17:29

vlookup with if statement?
Hiring tab: Column K: Band (either 5,6,7 or 8); Column D: Source (either ITSO or GMT), Column M: Country (Buenos Aires, etc) List tab: Column I: Band (either 5,6,7 or 8); Column M: GMT Salaries; Column N: ITSO salaries; Column O: Buenos Aires Salaries In Column X on the Hiring tab, I want to put the salary t... 2 Feb 2010 17:29

Clear row label data in pivot table
I'm using Excel 2007 and I replaced all the data in my datasheet except for the headers because I wanted fresh data but didn't want to have to create all new pivot tables. Now, when I go to the pivot table and select row data, the new values are there, but the old values are also there. Is there a way for me to rem... 2 Feb 2010 17:29

Saving from 2007 to 2003 - 2003 won't open the file
I have a user that has Excel 2007 - She saves the spreasheet in 2003 format (Fiel is almsot 50 megs) When the 2003 user tries to oepn it, she get a error message: Excel cannot complete this task with avaliable resources. Choose less date or close other applications I have rebooted her machine and opened nothing... 2 Feb 2010 17:28

Index and match formulas
I am trying to use the index and match function to pull data from one table into another. If I had the table below (which is A1:F7) does anyone know a formula that could look at coloumn "F" find all rows that have the "30" and pull info from column "B" into a specified cell (J1). When I use =index(a1:f7,matc... 2 Feb 2010 17:28

Change the black selected-cell-border to another color (cursor)
How can I change the cursor color in Excel? Normally when you stand on any cell, the selected cell shows a black border with a dot in the right bottom. When you have a sheet with different border styles, it is difficult to see which cell is selected. How can I change that cell-selection-border color? ... 2 Feb 2010 17:28

How can I view comments in a pivottable?
Hello, in the original data there are comments added to particular cells. However when I create a pivot table of these data, then I do not see the comments in the pivot table. Even on the lowest level. Can I make these comments visible and how in Excel 2007? Thanks in advance! ... 2 Feb 2010 17:28

Insert blank row after change in cell value not working.
I have used the Gord's VB code posted on here to insert a blank row after each change in cell reference without problem several times. I now have a worksheet that will not run it correctly. It now inserts a blank row if the cells text colour changes, although when I paste these different cells into another wor... 2 Feb 2010 17:28