Hi there, I hope someone can give me an idea. I have quite a few file
that are in the csv format. I can open them in excel. The problem is
that they are very large and I get a message saying the the file did
not load completely.

I would like to know if it is at all possible to run a macro via a button of
as soon as a cell's text is formatted a certain color that the cell's text
and complete row is moved to another worksheet?
Thanx in advance

Can anyone tell me these key combinations?
       to tab between worksheets in a workbook
       to insert a tab in the text in a cell
Is there a list of these kinds of key combos anywhere?  

I have a worksheet with data and several charts.
I'd like to have an additional worksheet with copies of those charts that
are linked and updated whenever the charts on the first worksheet are. I
think this will make it easier for me to make the acrobat files I want.

Does anybody if there is a way to have a square the changes sizes based
on given imput cells?  I want it to work the same way a dynamic graph
does but I didn't seen anything in the graphing section that would
work.

Using Autofiltering to get a "custom view"
The custom view does not seem to work on any
new records that I add to the database.
Is there a way around this?

I am planning a sales trip to Honolulu, HI and I want to prepare an account
list for the accounts in that area.
In cell A is the store name; cell B is the address; D, is the City; E, is
the ST & in cell F is the Zip.

I have a an Excel worksheet that has about 3,500 birthdates entered.  The
format is if the person was born on january1st of 1960, it would look like
this:  19600101.
The program I use to calculate my work needs these formatted in the

Is it possible to set an xsd schema to import data in excel from an xml
file?
Excel "intelligent" way to import data from xml is too "smart"!
We have phone numbers that begin with 0, and excel thinks that are numbers

Create an Excel spreadsheet to track the monthly inventory (start with
Oct.2003 and run through Sept.04) of the following items: pens, pencils,
lapel pins, bags, Visitor Guides, etc. Title the Spreadsheet "JCVB FY 2004 AD
Speacialty Inventory"

I have two separate databases in Access that have a common field of CustNo.
I'll like
to run a query in Excel using Get External Data... whereby I could create a
report that brings in data from both the databases.

I am trying to use the Vlookup and am having some problems with it.
I have 1 sheet that has my the info I'm search for on 'book1'.  Here is
my forumla:
=VLOOKUP(A6,'[Book1]mar page counts'!$1:$65536,2,TRUE)

Hi- I am using vlookup where the lookup table is in another file, I
have the file name in a cell of the sheet, please let me know how to
refer to the file name and range name in the vlookup function by using
the cell address that contains the file name.

I have a macro running agaist 40,000 line items and keep getting an overflow
error.  I've seen this b/4 but can't remember how to fix it.  Help?
Dan

Is there a way to count the number of "N",s in a row.  How would you handle if the "N" is "n" or "N" colours.
Many thanks Darren