Hi Im trying to setup a system for our 'goods in' the attached shee
would be on a pc at the 'goods in ' area hooked up to our network. I
the office we have a individual parts list for each job. I want to b
able to input a component on the parts list and when I enter a orde

I need to enter elapsed start and stop times (military time, as hours
and minutes) into a spreadsheet, for calculations of elapsed time in
minutes (calculation used: stop time - start time * 24 * 60).  
I hate having to reach over to enter the colon between the hours and

I have one cell that is deleting itself when I open the invoice.  I retype
the name in, save it, then close the program. When I go to reopen that
invoice it breifly shows the typed name and then it disapears.

When I try to format a cell in a workbook, I am getting an error "To
many cell formats."  Does anyone know how to fix this error?  Thanks i
advance for your help
--

this is the formula in cell L84
=D84+G84+J84
but if i enter a value in K84 then i would like L84 to change to tha
value

Is there a way that a header row can be printed on each page of
multipage document without manually inputing the header row at th
start of each page.  We may be adding more information to a page tha
will cause the "page breaks" to change on each page.

I want to be able to return a count where the cell in columns J and M are
both "X".
Example: Colums J through M are cars andColumns N through O are the repairs.
I want to be able to count by car, how many times for each repair. So I

When I use Goal Seek, the result cell returns a calculated value of,
for example, 55.6138.  I would like to have this value rounded to 2
decimal places i.e.  55.61.  Does anyone know a method by which this
can be accomplished?

I hope someone can point me in the right direction to count whether certain
cells have a value.  Beginning in Column C, every fourth column (C, H, L,
etc) out to Column DH may or may not have a value.  I would like to count
how many do have a value in each data row.  Is there a ...

I want to make this symmetry curve more smooth.
these pair is 0 and 27, 1 and 26, 2 and 25, 3 and 24.........etc.
the highest of  curve is on center, and the lowest of  curve is on two side.
i try take pair points on two side, averages to a new point. it will be a

Posted: Mon Aug 21, 2006 9:17 pm    Post subject: Conditional Drop-down
--------------------------------------------------------------------------------
Greetings,
I have a question and if any of you guys could help, I would very muc

HI again all,
what I'm after this time is a way to hide a cell by using a formula.
This is pretty much solely for formatting reasons so that the sheet can
be cut and paste into word from excel without empty cells coming up.

I'm quite new to VBA, so I apologies if my knowledge of code is a bi
flaky. What I'm trying to do is a 'For-Each' loop through a larg
range. The code should check the corresponding range in a another shee
and if the value of that range is not empty, copy that range into th

Can any one of you please help me to get rid of the default excel dates to
standard format dates.

presently I link b1 and f1 of "payment" sheet to d1  and e1 of anothe
sheet.
What function should I apply in e1 when I link b1 then in e1 cell th
f1 value should reflect automatically.