I have three files with data about a set of individuals where each
file has different fields.  The largest contains last name, first
name, address and phone with data on about 8,000 names.   The second
is a smaller file with last name, first name, address in a different

I created a work book which I wanted tp print out A4 size.  When I go into
print preview my work is tiny about 2 inches square.  When I print it come
out the same, yet when I want to work on the book its a normal screen size.
How can I print it off A4 size Office2007

Try to insert a number 2100000037200351 into any cel. The number is
converted to 2100000037200350.
Others numbers too. Ex: 2100000037200395 is converted to
2100000037200390.

I want to report the number of times a particular item occurs in a
text string that is in a single cell.
For a simple example, If I have the string ABCABCABC....with 100
letters, how many times does the letter A occur, or the pair BC, and

I have spent some time looking threw existing posts and I can't seem
to find an exact answer to my problem.
If you can help....much thanks in advance.
It boils down to this....I want to do a vlookup for a text string,

I have a situation where I'd like to change the freeze pane headers
when a scroll hits a certain line.  For example:
FROZEN HEADER 1
data

I have a large worksheet with about 200 named ranges.  I would like to copy
this worksheet and all the range names to other Excel files (workbooks).  How
do I do this?
(When I copy the entire worksheet to another file, the range names do not

HOW CAN I CREATE TWO COLUMN WIDTHS IN THE SAME COLUMN... BUT IN A DIFFERENT ROW

A number of years ago I made a data table and inserted some simple formulas
in two or three end columns. Each year I simply add another row and copy the
one above. This time I noticed that the cells I copied to the empty row
carried the results of the calculation above as though ...

?

I have recorded a macro to automatically import a file and then run a number
of filters through it and to display the results in a separate worksheet.
I do not have any Visual Basic knowledge, so am just using the "record
macro" function. So far so good, but now I've run into a ...

I have recorded a macro to automatically import a file and then run a number
of filters through it and to display the results in a separate worksheet.
I do not have any Visual Basic knowledge, so am just using the "record
macro" function. So far so good, but now I've run into a ...

How do you properly copy a range of cells into a new worksheet or for
that matter into a different place in the same worksheet without
losing your reference cells.
I have ASAP utilities, and this box comes up but I don't understand

I am trying to create a macro that will copy the values of several
different ranges from a series of identically formatted workbooks to a
single new file to create a database.  So far I have the following
code that does what I need for a single file, but I need to have the

I have a list of 176 items and another list of 870 items.  I need to
see if the items in the smaller list are on the bigger list.  There is
no guarentee of any ascending or descending sort order.  And I need to
match two values in the same row.