I am copying a database fron access into excel; due to the size
(100000+ lines) i have to put it on two excel sheets.
i will like to do a vlookup that will search both sheets for the
result i am looking for.

In Excel
How do I ID the specific cell that has fallen out of sequence in a list?
Example:
A1= 1

I have a workbook that contains several copies of a master template
worksheet.
On one of these sheets when I enter text, it appears correctly in the
function bar, but appears as a string of &s in the cell.  This has only just

I'm new to the forum, so please forgive me if this subject has already been
addressed...
I have great problems opening more than one workbook at a time.  Excel works
ok if I open it, open a workbook and then open it again to open the second,

I want to count data in column B if there is data in column A.  If a
cell in a is blank then I don't want to count it.
7 s
4 s

You can also let others in the Community know whether they should bother
reading a post or not by rating posts. If you find the information in a post
useful, chances are that other people will too.
Here’s how it works. The system keeps track of positive and negative

I'm just looking for a guy to talk too, maybe hook up with?  Anyone?
http://www.gjef.com

To get this format of date in cell B1, with my abbreviated days:
071117.Sa
I was given the cell formula of this:
=IF(A2<>"",TEXT(A2,"yymmdd.")&CHOOSE(WEEKDAY(A2),"Sn","Mn","Tu","Wd","Th","Fr","Sa"),"")

Is it possible to password protect your macros, so that no one can mess with
them or update.
Thanks,

Really simple one - bit new to excel!!
All I want to do is display what is in cell A1 worksheet 1 in cell b1
worksheet 2.
Cheers

I have about 400 addresses to enter in. I was wondering if there was a way,
in excel for me to type in a zip code and have Excel fill in the city and
state automatically.

The macro shown below will convert any Long number to the text
equivalent (both +ve and -ve).
Thanks must be given to:
http://exceltips.vitalnews.com/Pages/T0351_Numbers_Spelled_Out.html

I have a woorkbook with a master worksheet which include formulas.  I
want to copy the master into individual sheets but maintain the
various formulas.  How can I do this

is there any way of specifying a range of non-contiguous cells? E.g., if I
wanted to sum every third cell, rather than going =SUM(A1,A4,A7,A10) is
there any notation I could use analogous to =SUM(A1:A10)? I'd prefer to
avoid macros in this instance if possible.

Is it possible for me to create a macro so that when I click a button, a
combo box is hidden?
I'm using Excel 2007 and Vista Home Premium if that helps
Thanks