General

How do you do the following using VBA macro automatically?
Hi all, I would like to have the following run every time when the Excel 2003 sheet is opened: so I am going to put the VBA macro into AUTO_RUN function... Now when the Excel 2003 file is opened, I need the following: 1. refresh/recalculate all the sheets in the Excel 2003 file; 2. save all the sheets;... 4 May 2010 15:42

sorting
Is there a way to search an entire workbook for keywords and return the entire row? The same as "sort" does on one page, just across the whole workbook. ... 4 May 2010 15:42

rows to repeat at 'Bottom'
Currently, MS Excel has the option to repeat certain rows at the top of the document. It would be lovely, very lovely actually, if the option to choose rows to repeat at the bottom were an option. To date, 90% of our documents need this 'title' information to be at the bottom of the page. Any help with thi... 5 May 2010 19:25

How to combine data based on two fields..
Let's say that you have a spreadsheet with three fields, like: Year Group Value 1970 1 3 1970 1 1 1972 1 1 1973 1 5 1974 1 2 1974 1 0 1974 1 2 1970 2 1 1970 2 1 1973 2 2 1975... 4 May 2010 15:42

Lookup a particular cell in another excel workbook
I want to be able to type in a workbook name in cell A1, example "05-03-10 Sales", and in cell B1 pull in cell A3 under the tab SALES in that workbook automatically. That way the date can be changed randomly and it automatically looks for that workbook. example change "05-03-10 SALES" to "05-04-10 SALES" and ... 4 May 2010 17:59

Copy loses order of Conditional Formatting rules
Hi- I have tried multiple times, and I am losing the order of conditional formatting for a cell when I copy it to another cell. The relative reference copies well, and things work if correct the order of the copied rules. I found references on other discussions forums that this is a bug in Excel, but, I didn... 4 May 2010 15:42

custom number format
Can a custom number format be created to format a value such as 9,999,999.25 to format 9 999 999,25? I know the # ### ### works to add spaces but I can't figure out the decimal and don't want to change regional setting. Thanks, Jake ... 4 May 2010 14:35

Pivot Table Column Totals - XL2003
I have a pivot table that only has column header and data fields - no row area. I would like it to show totals for each column, but nothing happens when I check Grand Totals for Columns in the table options menu? ... 4 May 2010 15:42

Protect/unprotect ALL worksheets in workbook ?
I need to know how to protect the entire worksheet (all tabs within it) with a click of a button; not sure what the last solution entails. Please help. ers ... 4 May 2010 13:29

tool bar missing
I accidentally moved the excel up so that the toolbar is above the screen. How do I move it back down since I can't see the tool bar to grab it? ... 4 May 2010 14:35