I am having a Text (.txt) file . It contains a record like this:
CalledNo  CalledDuration     Date
12354      04:50                  10/10/2005
4789        12:30                  12/25/2005

I have a spreadsheet which contains a summary sheet and then a number of
detailed worksheets behind that. Is it possible when entering details onto
the summary sheet to then automatically create and name a new worksheet?
Possibly from a template worksheet?

Hiya
Is there a way of calculating the number of Saturdays between two dates in
Excel?
Thanks in advance

If my formula is K9*7/250=3.56, how do I get the result of 3.56 to round up
automatically to 4.0????

I have set up a folder with sever linking worksheets. On these sheets there
are some cells which are constants and some which require input. How do I
protect the sheets so that the constant cells are not altered but alow users
to input info in the requisit cells?

My first tab is a summary and looks something like this
A1                                  B1                        C1            
         D1
Status                             Total                    D                

I have a spreadsheet where I want to count the number of sick days for
individuals.
So I have the name of the person in a column and the date for the year in a
row

I am trying to find a way to link photo's from a file to seperate excel
worksheets. the thing is it's on a mac and the link option does not
come up. Another thing is that i want the photos to be placed on the
excel sheets corresponding to each category automatically. if this is

Hi!  I have a data dump I am running several macros on.  One macro I would
love to run is to convert a column of text numbers to numerical.
Excel does recognize them - I get the little green tirangle.  But anyone who
uses Excel XP or 2003 (which I do) knows that formatting does ...

I have a rather large macro, and I want to give the user a chance to exit the
macro before it runs. I need a msgbox (or a dialogue?) with a warning, and
the user will select either OK (to run the defined macro) or cancel (to exit
and not run the macro).

I have prepared a pivot table for equipment avalability, in which I can
select the required equipment, following which I can see the avaiability
status, which is being maintained in another sheet.  Now, I want to create a
link of that particular equipment (selected in the pivot ...

Trying to get excel to show me certian cells  inbetween two dates.  so if the
dates were 8-20-06 to 8-30-06 i need excel to show a word from a linked cell
from 8-20 and every cell between to 8-30 so that word needs to be in every
date the 21st 22nd 23rd all the way to the 30th.

I'm learning to use macros,basically by using the record mode.
I recorded yesterday about 20 macros and all worked perfectelly.
But today....
I have two worksheets to work on. I record one macro in the first worksheet,

Its very simple.  I want to input text into column C  I want it to search
column A to find the same value and then return the results of column B.
Column A  Column B                   Column C
0OK7    Haskell, OK                                     

I want use bullet in the excel cell with indent text. Could you please help
me, thatnks.
Waiting positive response.