Excel Tips
Use Index and Match to Lookup a Cell to the Left of Key Cell »
May 23, 2002
How to use Index and Match to lookup a cell to the left of key cell
Change the Worksheet Tabname to Reflect the Value in a Cell »
May 22, 2002
Is it possible to change the worksheet tabname to reflect the value in a cell?
Greenbar Formatting In Excel »
May 21, 2002
If you are over a certain age, you will remember when all computer reports were produced by the MIS department using COBOL and a high-speed IBM Line Printer. These reports always printed on paper called "Greenbar".
Formula to Point Always the Same Column »
May 21, 2002
Formula to point always the same column but is free to move to different rows as it is copied.
Convert 11.5 to 11 Minutes and 30 Seconds »
May 20, 2002
If I have 11.5 in a cell how do I get this converted to 11 minutes and 30 seconds in another cell?
ActiveCell instead Named Range »
May 20, 2002
How to change the macro so it writes the data to the active cell rather than a named one.
Run a Macro Automatically When the Workbook Opens »
May 19, 2002
How to get a macro to run automatically when the user opens a workbook.