Excel Tips
Macro When Excel Cell Changes »
June 25, 2002
Excel to run a macro every time a value changes in the Excel spreadsheet.
June 11, 2002
I need to import a file daily. I'd like to add the file each day to an existing Excel workbook and have the worksheet named for the d/m/y.
June 4, 2002
I have imported a file into Excel. The zip code is broken into 2 cells. The 5 digit part of the zip code is in column E, the 4 digit part of the zip code is in column F. I need to join them into a single cell.
May 28, 2002
Search a column and highlight red the cells that contain today's date.
Increment a Counter Everytime a Userform is Opened »
May 25, 2002
How to increment a number by one each time the user form is opened.
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