Hi all please help me out. I am new at excel. I need to create a sheet to log
in our inventory and be able to add to it when we get parts in and subtract
from it when the techs take parts. Is there a way to do this?
Thanks and sory to sound stupid.

I use the sumproduct formula and refer to cells containing text. In this
case, the cell can contain either 'Buy' or 'Sell'. Now sometimes Excel does
not recognize the text in the cell correctly. When I re-enter the text, it
does recognize it. How is this possible and how can I ...

I recieve an updated spreadsheet each month showing the newer entries
at the bottom of the sheet. What i need to do is find a way that this
newer data can be compared to previous entries to see if it has been
entered before (i.e Mr Smith was entered in Jan and again in May)

I've looked at a number of "to-do list' templates and have not found
any that provide what I'm looking for. I'm wondering if it's possible.
I'd like to have a task list that tracks items for several different
projects. Column headers would be something like: project, start date,

I am going to demo my question with a simple example
I have the following data:
StockNo, Date, Sales, Boxes
A             xx       100      10

Does anyone know whether there is a preferred way to dissallow users
from deleting formulas (and data) in a column?
I have a shared document that contains formulas in certain columns. On
occasion, users will likely accidentally delete the contents of those

I am saving sheets out as html.
The problem i have is they are all one sheet with a menu bar placed on
the bottom.   Is there a simple way to have excel save without this
meny bar?

I have an issue when taking an Excel 2003 sheet and exporting to a CSV file.
I know the steps and all works fine but.... how Excel creates the .csv file
if there is a 0 in a cell of a row instead of putting the 0 in the .csv file
it just leaves it blank.

My system:  Vista Business 32bit with SP1, Office 2007 Professional with SP1.
For a while I was running Vista (without SP1) and using Office 2007 with
SP1.  Rarely any issues.
Sometime after installing Vista SP1, I've been having odd issues with my

I have a workbook in Excel 2007 that contains cells which are external
references of another source. This is a monthly workbook that I now wish to
save and transfer to a disk for storage. I believe that I will lose the
amounts shown if the formulas are not converted to value ...

I want to create an array formula but need help for a condition that refers
to the cell's color.
 My formula would be like this:
           {=SUM(IF(condition,VTC,0))}

A small peculiarity that I'm hoping someone can help me clear up.
I have a number of large number of similar workbooks (different data
in each).  They each have a number of charts.  When I enhance a chart,
I then want to ensure that each workbook has the same type of chart.

I'm new to excel 2007, i have created a vb command button on excel
sheet but that button is by default in design mode (if i click on
button it takes me to code). I want the button in run mode, normally
in excel 2003 there is vb tool bar and from there we can change the

I have two lists on separate sheets in the same book; each contains a common
field in column A.  One list is much longer than the other, and both are
over 5K rows.
In the longer list I need to show if the common field appears in the other,

Good morning everyone,
I am hoping that someone can give me a hand. Recently I downloaded a
file that is work related, when I attempt to open this file with the
Microsoft 2003 Excel viewer I receive the following error: "Microsoft