I have created a workbook that has several worksheets that contain formulas
referencing the different worksheets.  One worksheet contains the data used
in another worksheet.  Then that worksheets data is used by a totals
worksheet.  There are multiple workbooks that use the same ...

Column K is Amount
Column L is GP (Gross Profit).
Columns A through J include my qty, vdr name, vdr #, vdr price, etc
As I add additional vendors and information, I want Excel to keep

I'm updating sports scores in excel 2002,  The first set of Columns Are the
Team Names and the Final Score of the Game (These 2 columns update after each
game).  My other 2 columns are used for notes and other information.  When
ever I refresh the data, the first 2 sets of ...

Sometimes I have data which I enter as :  <0.05
How do I get Excel to use the cell's entry as 0.05 for further calculations?

I am creating a command button then adding code with this syntax.
   With objActiveWkb.VBProject.VBComponents("Sheet1").CodeModule
       StartLine = .CreateEventProc("Click", strButtonName) + 1
       .InsertLines StartLine, _

Good morning, all!
I have a cell in my Excel 2007 workbook which is dependent on the value of
cell A1. The result I want in cell A1 is either 1, 2, or zero. The formula
in cell A1 is:

Hi there, i'm attempting to implement a cross-sheet formula to count the
occurances of a single phrase or grouping in one sheet, producing a simple
total figure in a cell in another.
To put it into real terms, in one sheet there is a collumn with a series of

I am using Excel 2007 on Vista Ultimate.
Importing a text file (txt and/or CSV) using "Data\Get external data\From
text" and changing decimal separator to point (from comma) in advanced
settings gives me an issue, namely that the applications keeps changing the

I have a thousand cells that take up a thousand rows with information in
them and at the far right of each cell I have a note like: info 1, info 2
info 3. What I wanted to do is line that peace of information in a straight
line within each cell. Trying to do it manually is a pain ...

I am not sure I can explain this clearly but I will give it a shot
The cells are formatted to show time
Cell  A4 you enter in 1 or 2 to have cell A3 show the info from cell A2 (if
1) or B2 (if2)

I have a shortcut on my Quick Launch bar to a file called Index.xls wherein other hyperlinks take me to a zillion other places as
a means of organisation of my computer data.
For a couple of months I've been finding that whenever I click Index.xls another file called PERSONAL.XLS ...

I am writing a spreadsheet program and will offer it for sale in a
downloadable form.
Being an executable, I am concerned if I will have trouble with my customers
being able to receive the file past their companies firewalls.

When referring to:
   With XLDestWB.VBProject.VBComponents("Sheet1").CodeModule
is it possible to refer to the code by Sheet1's tab name (e.g.
"TabOne") rather than "Sheet1"?

I have an excel file with a ragged hierarchy as shown below, I would
like to structure the data in a different format (also shown below)
please help.  Also the data below is just an example the actual data
file is much larger and the hierarchy has 10 levels the lowest level

Is it possible to change the width of the text box for 'Category Name' within
the data label on a chart?
I have Category Names which are very long and need to be 'word wrapped', but
I cannot change the width of the text box or find a 'word wrap' option for