I have a spread sheet with a few merge cells that I can not unmerge.  I've
used the on-line help but was still unable to find the right operation to
unmerge.  While on-line I did see this note
Note   If the Merge and Center button is unavailable, the selected cell may

I created a DV with multiple selection using Debra's code and made minor
modification.  It worked before but now it does not work.
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)

I need to create a query that will search about 10 individual date fields
to see if any of the dates are: greater than 30 days prior to, or 1 day
after the
<pdate>.

A      B              can somebody help with a formula in the B colunm so
that it
1        1            give values added upwards in the A colunm
2     (1+2)

Can someone tell me how to resolve 'data source reference is not valid' error
while creating a pivot table

I have column A with text & column B blank or with percentages. I would like
column A to be formated bold when column B is blank!
Example:
     Now                              What I would like

Let say I have the data and I want to fill in the data in another sets of
table. All i need to do is to put"=" and it will copy. What if I want to drag
the copy by changing the colum for example I will drag from A1 and rather
than it will change to A2, I want to change it to B1 ...

Please I need an example workbook that containts something like the
one in this address http://www.xldynamic.com/source/xld.Dropdowns.html
You can send it to my email khaledity@gmail.com or you can send me a
tutorial on how to do it.

I have this formula, b = n (∑ty) – (∑t) (∑y)/
                                   n (∑t2) - (∑t)2
and for each column I already assign with the function. I just don't know
how to key in in one column in order the calculation will come out

I need a formula to look at column AF to compare the date, then look at
column N for the work "rejected" then sum the total rejected's between 3
spreadsheets, and enter the output on sheet 5. I have one formula so far, but
can't seem to figure how to add the comparison for the ...

Because of a backlog with our .NET programmer, I am working with a
report that was extracted from an SQL database to an Excel file.  I
have linked the Excel file to Access to provide reports in a specific
format so that all I have to do is run the extract then overwrite the

I was showing someone how cool the Autofill/Custom Lists were.  She had a
list of 30 names.  We highlighted those 30 names, clicked on the Office
Button, Excel Options, Edit Custom Lists, Import (the range was already there
because we highlighted.)  The list of 30 names showed up ...

Right now I have a worksheet with a lot of e-mail addresses in a column.
Now I want to put the domain name for each of these e-mail addresses in the
cell next
to it.

Where I work, we are all running Office 2007, Active Directory, and
Outlook connects to an Exchange 07 server.
One of my users is having a strange problem.  Whenever he tries to
open Excel files from within Outlook, it can take up to 2 minutes for

could any body tell me if it is possible to create a formula that allows you
for example to input a number in worksheet 1 and for that number to
automatically appear in worksheet 2?