I have a working Excel 2000 app, where users see and manipulate data through
forms rather than worksheets.
Can you recommend a method of making this app available to more then 1 user
simultaneously?

I'm trying to create a date in cell A4 from text in cells J1 & K1.
J1="May", K1="2006". Is there a way to create a formula in cell A4
using a "1" for the day, and the month from cell J1, year from cell K1
that other cells would recognize as 5/1/2006?

I am using a formula to look up a manufactures price for parts from
list =INDEX(Sheet2!G:G,MATCH(A3,Sheet2!A:A+0)). Sheet1 is my list o
pn's, Sheets 2,3,4 etc are the mfgs. list for various product lines
This formula returns #N/A for some as they are not all on every list.

I am limited to just the colors I see when adding a color under the patterns
option? AM trying to add color #34349C and there seems to be no way to do
that. Can anyone help? Thanks much.

Working in Excel 2003. Is there any way that when entering data on one
worksheet, that it is also automatically entered on another worksheet within
the same workbook at a designated location? If so, then how do you do this?
Thanks much.

How do you turn the cell borders off or on?  That is, so you can have each
cell with a light border or no borders?  thanks to all

Hi:
Happy new year. I have created an Excel report. In its center header
put a text. Now how can I change the font size of this text in cente
header to 12.

Can someone tell me how I can get the fonts on the bottom tabs on
worksheets, the defining tabs
I can change the colors and names and everything but enlarge.
Also is there a way to keep what you choose in option too happen all the

I am a beginner at this. Using Excel, all I want to do is to multiply 2
columns  together to give a third column. For example, a list of numbers in
column A against a list of numbers in column B to produce a column C - (A2
times B2 to equal a number C2))  

I would like to put the filename in a cell, just the actual name though, not
the "c:/blah/blah/blah/blah part? Is there a way to truncate the filename?
Thanks in advance!!

hi Im new to excel I seem to lose my formula's everytime I go back to
enter some data that I may enter wrong for example I have put the
formula in and go back and put a number in the cell and find it's the
wrong # so I backspace or hit delete and I lose my formula and clear

Once again I am having problems creating a formula for a worksheet I am
creating.  I have three columns - first on is cost of labor; second is cost
of parts and third is total of the two previous columns, no problems there.
What I want to do is if there is no values entered in ...

hi
my boss gave me a  worksheet that has 5 graphs working off of it I need
to change the dates in the graph so it will be updated to things Im
entering in it now

I have two problems:
1.  When I print out a page the printing is too small
2.  In my date column, the last two digets don't print when I get to a date
such as 12/22/05.

Hello Excel professionals,
I have a sheet and a macro that I want that macro auto run when that sheet
is in active.  I looked in Help for AutoRunMacro, but I don't know how to do
for this macro.  My macro is just to change color in a correct cell when it