Hello, I have a list of names in column A (a subset of the names on list B)
and a list of names in column B (the entire list of names). Is there some
way to compare the two lists and highlight, copy elsewhere, or somehow flag
the names that are in list A but not in list B.

Can Anyone Help Please? I have made Blocks of Differant Data and they use
2 Columns Like a "List" But not Linked as they all Have their own Borders And
Are Formulated mostly the Same, and  most Are NOT Merged, and contain 6 Rows
Each the first Column (Products) is (D) (50.63 ...

I am attempting to Create a sequentual serial no within a template ( for
invoices / quotes) within a particular cell in the template. So when I open a
new workbook from the template it increments the invoice serial number by
one. Pulling my hair out with this one.

I am not sure which newsgroup to use for this one.
I have SBS 2003 SP1 with Exchange SP2 and XP SP2 workstations. I just bought
a new phone with WM6 on it and ActiveSync works great for Exchange stuff,
but I have a problem with Excel files. I have a spreadsheet for my mileage

Why Does My Dropdown List Always open at the end of the List instead

I have a big table preparing for a community telephone directory with these
entries:
=(CONCATENATE(N6377,", ",L6377," ",M6377," & ",O6377," ",P6377," ",Q6377))
 L           M      N       O          P     Q                Result

We have eight excel files each containing 12 sheets with 33 names on
each sheet (296 names per file)
The same names feature in each of the files.
We record daily/weekly payments against each name and we are trying to

I build large spreadsheets for my clients. Recently a sheet that I built gave
me a new problem. The sheet contains over 100 macros. I tested all of them,
and they ran fine on my computer. When I copy the sheet to my client's
computer, I keep getting sent to debugging when I try ...

Hi Experts;
I require a macro, which can help me to consolidate data from
different Excel file lying in one folder. All these excel file would
be having two different sheets with similar name in all files.

I'm trying to export/import the results of an Access parameter query to a
particular range of cells in a pre-existing Excel worksheet. Can this be done
programatically, and if so, is it best to do it from within Access or within
Excel. I've tried several methods (DoCmd ...

What is the syntax to make for instance the cubevalue function pick up
parameter values from the spreadsheet so my report becomes dynamic?
I have the following statement:
=CUBEVALUE("datasource";"[Measures].[Volume]";"[Time].[YM].[YM].[2007].[200710]")

Hi, I have recently started receiving an error and some files will
not
work properly in Excel 97. The message says "Data May be Lost". I
think it started with the installation of Windows Internet Explorer

Excel help says it should be a tab under tools, but I can't see it in
my version.
I would appreciate any help.
Thanks.

I seem to have had the Address bar disappear.  Not
sure I'm
using the correct terminology but I mean the bar
at the top

I have a shared workbook which many users on different shifts modify daily.
Two users are complaining that every time they open the workbook, the cursor
defaults to a particular cell, rather then to the last place they worked
before saving and closing. If they do a "Find" before ...