Sorry if this is an inappropriate post for this area, but I'm not getting
very much of a response at the Word.vba site.
When copying text from the IDE into a Word document, I would like to have
the format match the format in the IDE, specifically changing the color of

I have a database of 20,000 transactions, each of which
contains a date.  I want to create a pivot table which
summarizes the dollar value of the transactions by year.  
Problem is that the pivot table looks at the date and

I have a timesheet spreadsheet that calculates time in / out.  Right
now I use the MRound function to round up or down to the nearest 1/4
hour.  Our policy says that if you are more than 5 minutes late, you
will be docked up to the 15 minutes.  Is there any good way to make

. . . not!
Just fixed 5 formula errors in a workbook I maintain. (Yes, I do make
errors in spreadsheet formulas.) The original and changed formulas were
From

I have some spreadsheets with incorrect formulas. I'd like to replace
the existing formulas with correct ones. I can't do a fill down because
there are merged cells in the column. Is there a way to do a find and
replace to change the formulas?

I have a worksheet that I need to calculate the actual amount of hours times
the hourly rate then have the total in another field. I can get it to work
if I just use the three fields but I would like to just have the hourly rate
in only one field then in a blank field add the ...

I have been having a problem with excel. Whenever I open a workbook I have
been working on (doesn't matter which, I happens on all of them) it opens
that workbook along with an extra blank workbook (book 1). Is there anyway
to stop this extra workbook from opening (i.e. a setting ...

Good Morning All,
Using Windows XP and Excel XP.
I have a workwork that contains 31 sheets (one for each day of the month)
and I have it programmed to open up

I want to do thing like this: If A1=1, then hyperlink B2 and KP (where
kp is a Name Box that exist somewhere in the workbook), otherwise leave
B2 blank.
How can I do so?

In a spreadsheet there are 4 tabs.  Each tab covers a year (2000-2004).  Each
tab also is identical in column names.
How do I make a page that combines the contents of all tabs and will update
as I update the related tabbed page?

I am looking for information on inserting an underline. I do not want the
underline under just the number and I don't want the border option. I belive
there is a format option that will make a line that goes across the cell but
just short of the end of the cell edges. I would ...

I would like to be able to sort the same column in all worksheets in a
workbook.  I found two macros that were similar in this discussion group but
have not been able to make them work.  The key column in each worksheet has a
different number of rows but it is always the same ...

I'm using the formula :
=TODAY()-30
The workbook remains open overnight.
When the date changes, there is no change in the cell value. I'll appreciate

I have a worksheet where I have used the group buttons to hide details in
the rows under a summary row.  When I sort on columns, the detail rows get
lost in the sort.  In other words the detail rows are no longer below the
correct summary row.  Is there away to keep the rows ...