I have a group that installs a Digital Certificate I created to enable use of
my spreadsheet macros.  Because one of my macros inserts a new worksheet,  
this removes my certificate once the user selects save (and they have to save
the worksheet).

Please help.  Can this be done?  On WS 1, there is lookup criteria in
cell A2, a date in cell D2 and another date in cell I2.  On WS 2,
there is a table with the lookup criteria in cells A2 thru A9.  I
would like a formula to add the number of months from a cell in the

I am in sales and see many different clients everyday. I use excel to colate
data about clients for among other things to keep track of who has paid and
who hasn't.
I need to collect this information and make a master report that I can

Does anyone know of code or a link to a spreadsheet which can create a
rudimentary Gantt chart in ecxel?

How do you convert a pivot table to a regular excel worksheet?  All I can
find are instructions on how to convert excel worksheet to a pivot table but
not the other way around.  I do not have a data source file since the pivot
table was e-mailed to me.   I need to combine this ...

I am trying to compare, two huge outputs from different databases. I have
combined them on the same worksheet, with one being highlighted. I am now in
the process of adding a conditional format to all the cells. I have two
conditional formats, each specific to the row.

I have a spreadsheet with over 60K rows that I need to update with an
additional column of data.  Unfortunately it would be too much work to repull
the data and get it formatted appropriately.  I was planning to use vlookup
to complete the update but so far has been very time ...

First off I thnk the Office 2007 Excel Workbook is somehow damaged because it
keeps doubling the size of the file each time we open and close it. Its now
up to 48mb and I know its not that large of a file.
What I want to do is copy a range of cells A1 thru N175 over to a new

I have a database in Excel, merging into a document in Publisher. There are
11 fields that are being merged. One of the fields are serial numbers, which
consist of just numbers and numbers and letters. All of the other fields are
merging fine, except this one. Some of the records ...

When I copy paste something into my spreadsheet the cell automatically turns
blue. Is there a way to fix this?

I discovered the following statement
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
now I want to set a var to the selected range.
Can anyone help; this VB stuff is all new to me and I really appreciate the

I am working on a forecasting spreadsheet and have item numbers in column "a"
and # sold in column "b".  I have run subtotal so it has added the word
"total" to the end of the part number.  I then copied just the totals to
another worksheet and I am trying to use the lookup ...

I want one column on the worksheet to be date and another column to be
accounting, but when I highlight one column and change the style, the style
changes for both columns. How do I isolate each column to be a particular
style?

INT(10^14+0.5) results in exactly 100000000000001.  INT(10^14-1+0.5)
results in exactly 99999999999999, as it should.
It seems that for all values of 10^14 and higher [1], INT() behaves
like ROUND(,0).  Why is that?

Is there any way to allow a pivot table to refresh with a protected sheet?  I
have the cells containing the pivot table "unprotected", but when the sheet
is protected it still won't refresh.  The "refresh data" option is grayed out.