How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the

Is there a way, in Excel 2003, to have a template with default text in
the cell that disappears once the cell is entered? For example, in the
form I am creating, one of the cells to be filled is Event Name. Is
there a way to have "Event" appear in a cell such that it disappears

In cell A3, I have today's date (March 18, 2007).  I would like to copy that
cell down maybe 100 times.  I would like each cell to be updated by 1 day.
I appreciate any help I receive.  Thanks.

I want to search for a value in a cell that comes from a formula.   for
example, if I have =A1*A2=15.58 in cell A3.   I like to do a search for 15.5
and arrive at cell A3.   Is that possible?  thanks.

Periodically, I open Excel to find my custom toolbars are gone and no
longer in the Toolbars list. This has occured for a long time, but
it's really getting on my nerves now. I'm tired of rebuilding them.
Any advice on what could be causing this, how to prevent it or

I would like to know if it's possible to write a macro which
- open excel file
- select an area or graphic
- copy these area or graphic

I have a big table containing a lot of data in my worksheet. Within a
particular column, I want to select cells whose row numbers form an
arithmetic progression with a common difference 8(e.g. G6, G14,
G22, ...). At the moment, I can only perform this task by selecting

I am using W XP and Excel 2003.
When printing a spreadsheet I am not getting the gridlines printed.
I have checked Tools > Options > View > Gridlines.
I also checked File > Page Setup > Sheet < Gridlines.

Is there a way to take a pivot table and copy and paste it into a new
document so that the source data cannot be pulled up by the person
looking at it?  The reason I need to do this is because I have created
a pivot table and included in the source data is very confidential

lets say I have 10 colums in a worksheet, when in colum 10 of row, i want to
automatically go to colum 1 of row 2

I have a VBA macro in Excel 2003 that puts a word within text already
in a cell. I want this word to appear as normal font when the rest of
the text in the cell is in bold.
How can I define the font of a substring of a cell?

I have a worksheet that contains 3 seperate lookup columns.  My
challenge is that I need a low overhead way to find and count the
combination of true lookups.  So if one of the 3 looksup is found I
would get a return of '1', if 2 of the 3 are found then '2'.  I know I

I am wondering if there is a easy way to compare 2 pivot tables.
There have been many times where there is not a way to show a comparison of
2 sets of data in one pivot table.
What I have done in the past for scenario is to have a workbook that has 2

Please kindly help simplify the formula below such that the references
to A3, A4, A5...... could be a range (A3:A14) instead of individual
references.
={SUM(IF(('Sheet A'!$J$4:$J$37=A3)+('Sheet A'!$J$4:$J$37=A4)+('Sheet

I have the incredibly tedious task of trawling through peoples diaries
(Lotus Notes) for time slots when people are either free or busy (for
a potential meeting)
e.g.